• This will log deadlock info to the SQL Server error log:

    print 'Set on Trace Flag 1222 to log deadlocks'

    dbcc traceon(1222,-1)

    print 'Show all trace flags that are on'

    dbcc tracestatus(-1) with no_infomsgs