Scenario: Occurs when two or more processes block each other while waiting for resources, leading to a deadlock.
Error Message: E2059 - ECE_ForwardedSQLError: Native Error Code: 1205 SQL State: 40001 [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 120) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.