Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
FaisalMaqbool
Starting Member
1 Post |
 Posted - 2009-09-10 : 05:55:09
|
| A few days ago i have came across a problem that a table which was accessible last day was not being queried. I have write a 'select top X * from Table_name'. Its retrieving data for a small amount of data (200000) out of 3000000 but if i increase the value of 'X' in the statement with 'select top' the query never returns. Any suggestions what has happened ?I have truncated the table and loaded with data less the the day error has occur and its working fine .... but i need to investigate what has happened the day when data was not get retrieved from that table.Please let me know if more details are required. |
|
|
|
|
|
Table unaccessable