SQL Server >> sp_who and sp_locks on occurrance of deadlock
Hi.
I am supporting a client running sql-server standard edition, version
8.00.2039.
We have a deadlockproblem which i'm trying to dig into.
I've enabled trace flag 1204, but i'd like more detailed information when a
deadlock occours.
Is it possible to have the server deadlock handling procedure dump sp_who
and sp_locks to the log-file or another txt file when a deadlock occours,
preferrably before the victim thread is killed ?
> Hi.
>
> I am supporting a client running sql-server standard edition, version
> 8.00.2039.
>
> We have a deadlockproblem which i'm trying to dig into.
> I've enabled trace flag 1204, but i'd like more detailed information when a
> deadlock occours.
>
> Is it possible to have the server deadlock handling procedure dump sp_who
> and sp_locks to the log-file or another txt file when a deadlock occours,
> preferrably before the victim thread is killed ?
>
> Best regards, Erik
>
>
>