1205

Product

Name

Event ID

1205

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

LK_VICTIM

Message Text

Transaction (Process ID %d) was deadlocked on %.*ls resources with another process and

has been chosen as the deadlock victim. Rerun the transaction.

Resources are accessed in conflicting order on separate transactions, causing a

deadlock. For

example:

updates

, while Transaction2 updates

tries to update

but is blocked because

hasn’t yet

committed and hasn’t released its locks

Transaction2 now tries to update

but is blocked because

hasn’t committed and hasn’t released its locks

A deadlock occurs because

is waiting for

to complete, but

is waiting for

to complete.

The system detects this deadlock and chooses one of the transactions involved as a

victim. It

then issues this error message, rolling back the victim’s transaction. For detailed information,

see

Deadlocks.

ﾉ

Expand table

Transaction1
Table1.Row1
Table2.Row2
Transaction1
Table2.Row2
Transaction2