SP: NO COUNT ON, but still no records

D

Danny

I am working with Office XP, SQL Server 2000 with the latest service packs.

I have a sp that uses a temporary table to gather records to be displayed in
a result table.

The ‘SET NOCOUNT ON’ statement is at the top of the procedure and it works
perfectly in Query Analyzer.

Can anyone crack this nut?

I tried to append the code but the message will not post.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SP: NOCOUNT ON, but still no records 3
SET NOCOUNT ON, but SP does not return records 0
SP:Set Nocount ON, but still no records 0
the procedure executed successfully but did not return records 5
SET NOCOUNT ON, but SP does not return records 1
ADP: Error calling SP with "EXEC sp_helprotect" statement 18
Executing SP from Access form 6
'The stored procedure executed successfully but did not return any records' 4

Top