missing data

Last Post 26 May 2011 05:18 PM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

26 May 2011 01:51 PM
We have a small table (25 rows). When we query (website) it 
"select col1, col3, col6 from myTable"
sometimes (table is used daily by our customers) every 2-3 days customers are complaining that not all
data (25 rows) is displayed on our website (ASP). There is no block - timeout, I would have known that.
What can cause that behaviour?
New Member
New Member

26 May 2011 05:18 PM
Its extremely ulikely that SQL Server will not return all the rows. I suspect there is an issue with the web server code that may not load it all. But it is hard to say without much more info. I would check the code that selects and processes the results.

Acceptable Use Policy