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
 
Back
Top