We have a stored procedure that is called from a .net winforms application
every few seconds. The stored procedure always does a select, so there will
always be 0 or more records comming back. Every once in a while the dataset
returned does not have any tables in it, and I don't know what could cause
this? Has anyone else experienced behavior like this or have an ideas?

I am assuming you are using Sql Server. Try using SQL Server profiler to see
what's going on.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: blog.rthand.com

"Jeremy" <(E-Mail Removed)> wrote in message
news:#1AJn9z#(E-Mail Removed)...
> We have a stored procedure that is called from a .net winforms application
> every few seconds. The stored procedure always does a select, so there
> will always be 0 or more records comming back. Every once in a while the
> dataset returned does not have any tables in it, and I don't know what
> could cause this? Has anyone else experienced behavior like this or have
> an ideas?
>