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 |
|
Krishnaveni
Starting Member
1 Post |
 Posted - 2010-09-14 : 07:59:52
|
| Am getting the below error not always, but sometimes..Transaction (Process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.Warm Regards,Krishnaveni |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-09-14 : 12:08:14
|
| Thats nice, think you may need to find out what procedure this is happening on (you can find out by tracing the correct flags). Then find out what table you are getting the locks on and work out a strategy from there (you may need to change your isolation level). |
 |
|
|
|
|
|
Transaction (Process ID 65) was deadlocked on lock