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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-12 : 09:40:09
|
| Nicolas writes "Hi everyone. I have an Ms Sql server 2000 running on a PIII at 1Ghz with 256 Ram. I have a large Sql database (2Gb) and sometimes (i cannot exactly determine when) one of the table, called 'tOperation' stops responding. This is the largest table from our database, with more than 120 fields. It hapens even when i try to visualize the data from the table, with no insert/update/delete operations performed. I cannot have acces on the table untill i restart the Sql server. All this time i have full aceess on all the other tables.Thank you for your help !" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-12 : 11:28:05
|
| Try running DBCC CHECKTABLE on the tOperation table and see if any errors are reported. There is also an option to repair these errors (REPAIR_REBUILD), see Books Online for the exact syntax. This could take quite some time and can slow the server down, so you may need to perform this operation during off-hours. It would also help if you could set the database to single-user or dbo use only while you do it, to prevent other users from accessing it and to speed up the operation. |
 |
|
|
|
|
|
Sql Server stops responding