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 |
|
mohdmartin
Starting Member
22 Posts |
 Posted - 2007-08-09 : 10:28:51
|
| I received the following error message when run the query,Server: Msg 1205, Level 13, State 61, Line 1Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.how can solve the deadlock error ?regardsMartin |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-09 : 11:32:34
|
| the sql server will kill one of the processes or you can kill it yourself from enterprise manager. IN management current activity Locks/process IDAshley Rhodes |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-09 : 22:08:12
|
| Sql killed spid 61 already. You have to check your app to figure out why caused deadlock. |
|
|
|
|
|
|
Deadlock error