SP returns no records statement

  • Thread starter Thread starter KB
  • Start date Start date
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
 
KB,

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

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

-Andy
 
SP are not like access queries (views in ADP). Put the SP in a view then you
can see.
 
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
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Combobox Issue 2
SP in Subform Returns Empy Box for Some Users 1
ADP Update Query does NOT update ! 3
SP vs. SELECT Statement 8
Create a stored procedure from VBA in order to use DoCmd.OpenStoredProcedure with arguments 1
The stored procedure executed successfully but did not return anyrecords 1

Back
Top