I've upgraded to the lastest version of nettiers and I started with problems in customs stored procedures when i execute sql dynamically.
I search this problem in the forum and found an explanation:
"When CodeSmith tries to discover the type of resultset returned from stored procs, it does so by issuing the SET FMTONLY ON command to SQL Server. When this option is activated, the procedures are run with limited rights and therefore your call to an external stored procedure is not executed"
Then I found a "solution" that consist in construct the skeleton of the returned query.
I'm not really convinced with this solution, I dont'n understand what is happening now because in oldest customs stored procedures width dynamic sql worked OK. Would It be fixed in next releases? any other solution ?
I will apreciate any suggestion