I have a relatively simple SQL Server 2000 database which I am
querying from a VB.NET application. The query is very simple, such as
SELECT * FROM tblSystems. Let's say there are 10 records in the table
tblSystems. I expect to get 10 records from this query, and sometimes
do. But for some reason, I start getting 0 records from my app. If I
run the same query in SQL Server's Query Analyzer, it works fine. If
I reboot my machine, then it seems to work fine for a while, then
starts giving me bad results again. I am running my app on the same
machine as SQL Server, although I can connect to my database remotely
through my app, and I get the same results either way. Anyone seen
anything like this? Was this fixed in a service pack (I'm using SP1,
and don't want to install a newer one unless it's a known fix)?
Thanks,
Andrew