stored procedure does not return any records

  • Thread starter Thread starter George LAZAR
  • Start date Start date
G

George LAZAR

Hello!

I have an ADP project, MsAccess 2000 and MS Sql server 2000.
I have a sored procedure that is using temporary tables. In query analyzer
it returns recordsets, but when calling the same sored procedure (with the
same parameter) from access it does not returns any records.

any ideea?
thank you


George LAZAR
 
Put
set nocount on as prior to any sql statement that returns
counts or recordset/cursors.
Then add SET NOCOUNT OFF just before the statement to
return your record set.
 
Back
Top