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 |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-10-18 : 03:14:31
|
| We are getting the following error for MSSQL databaseTransaction (Process ID 101) was deadlocked on lock | generic waitable objectresources with another processand has been chosen as the deadlock victim. Rerun the transaction.how to resolve this.Regards,Rajasekhar |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-10-18 : 15:53:39
|
| If you had trace flag 1222 enabled, then the deadlock chain is in the SQL Server Error Log. Otherwise, you'll need to enable that trace flag and/or run SQL Profiler (deadlock graph) and wait for the next occurrence.With only the deadlock victim, there isn't anything that can be done to troubleshoot this.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
|
|
|
exception