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 - 2005-09-12 : 07:46:29
|
| Dhanhamsan writes "How can we troubleshoot deadlocks in SQL Server 2000 apart from setting LOCK_TIMEOUT" |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-12 : 08:10:39
|
| These are often caused by errors in the application code or the related sql. The best thing to do is to identify the code generating the deadlocks and to fix the software. Not create a workaround.====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
 |
|
|
|
|
|
Deadlocking in SQL Server 2000