How to trace the Error Log

Executed as user: WTC \ EBW. admin. transaction (process ID 95) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. rerun the transaction. [sqlstate 40001] (error 1205 ). the step failed.

This indicates that a deadlock occurs during job execution. We can useDBCC traceon (1222,-1)Command to capture the deadlock information. Every time a deadlock occurs, it is recorded in the error log. The error log file is stored in.. Mssql11.mssqlserver \ MSSQL \ logUnder this directory.

Close the trace tag and executeDBCC traceoff (1222,-1)

How to trace the Error Log