Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-28 : 08:21:53
|
| Richard writes "I am trying to diagnose some deadlocks on my database.I have called "dbcc traceon(1204)" for the connection submitting the query which is always chosen as the deadlock victim. I do not get any report in the Error Log when a deadlock occurs...Any ideas why not ?" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-28 : 18:31:54
|
| Try starting SQL with trace flag 1204-Chad |
 |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-04-28 : 18:55:59
|
| Here's an FAQ entry from my site, see if it helps:How to capture/redirect detailed deadlock information into the error logs?http://vyaskn.tripod.com/administration_faq.htm#q14--HTH,VyasCheck out my SQL Server site @http://vyaskn.tripod.com |
|
|
|
|
|
|
Deadlocking - trace flag 1204