Re: How can I create report after 1024 flag detect a deadlock?
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/15/04
- Next message: MIke: "Database Archive Data"
- Previous message: John Bell: "Re: How can I create report after 1024 flag detect a deadlock?"
- In reply to: Imre Ament: "How can I create report after 1024 flag detect a deadlock?"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 15 Aug 2004 18:05:12 +0530
Hi,
The trace flag to report deadlock is 1204, not 1024. Once you enable to
trace flag 1204 , automatically the deadlock information will send to
SQL server error log.
See the below link to get the details of trace flags and usage.
http://www.mssqlcity.com/Articles/General/SQL2000TF.htm
See the below site to enable the server side tracing:-
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
Thanks
Hari
MCDBA"Imre Ament" <Imre Ament@discussions.microsoft.com> wrote in message
news:40FCC6C4-F100-4C68-97D7-632788D4D5F6@microsoft.com...
> Hi!
>
> I am hunting for a deadlock and use SQL profiler and found the object that
> was deadlocked. To gain more detailed information from the deadlock I set
the
> 1024 flag on the server. How can I create the report what the SQL Server
> Books OnLine refer. Where write this information the SQL server 2000 (into
> error log?).
>
> Regards,
> Imre
- Next message: MIke: "Database Archive Data"
- Previous message: John Bell: "Re: How can I create report after 1024 flag detect a deadlock?"
- In reply to: Imre Ament: "How can I create report after 1024 flag detect a deadlock?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
