SP returns no records statement

K

KB

I am new to SQL server and project, very familiar with Access. Why does MS
Project return message every time i run a stored procedure that basicly
says "the sp was successful but did not return any records." When in fact
it does return records. Also why can't i preview the results like you can
in access? Thanks
 
A

Andy Williams

KB,

Try putting SET NOCOUNT ON ot the beginning of the procedure.

I'm not sure what you mean by your second question.

-Andy
 
B

BJ Freeman

SP are not like access queries (views in ADP). Put the SP in a view then you
can see.
 
K

KB

I tried SET NOCOUNT ON, still get message, doesn't anyone else get this
message?
Not sure why this is happening
 

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

the procedure executed successfully but did not return records 5
SP in Subform Returns Empy Box for Some Users 1
ADP Update Query does NOT update ! 3
Combobox Issue 2
Cannot show a resultset produced by a stored procedure 2
The stored procedure executed successfully but did not return anyrecords 1
Create a stored procedure from VBA in order to use DoCmd.OpenStoredProcedure with arguments 1
Returning Records from SQL 7.0 Stored Procedure in Access 2000 Pro 1

Top