Microsoft
Policy
Questions and answers to issues related to Microsoft: Windows, Applications, Development, Hardware, Server, Internet Protocols, Database, Exchange .
»
Development
»
MS SQL Server
»
DBCC TRACEON (3605,1204,-1)
DBCC TRACEON (3605,1204,-1)
Hi
I am having deadlock issues and have been reading articals on ee as to how to trace my deadlocks.
I have seen the command DBCC TRACEON (3605,1204,-1), can anyone tell me what I do with this? I assume I paste into query analyser but how do I or indeed is there an output to reveiw?
Also do I need to switch it off again? in short and as only one question can someone tell me how to use this command?
Thanks
internet advertising
Solution: DBCC TRACEON (3605,1204,-1)
I have used the information from the following link to trace deadlocks.
http://www.sqlservercentra
l.com/arti
cles/Perfo
rmance+Tun
ing+
and+Sc
aling/trac
ingdeadloc
ks/1324/
Popular Tags
Tags:
2000
2005
column
convert
data
database
date
datetime
dts
error
file
from
insert
log
Microsoft
mssql
name
procedure
query
select
server
sql
SQL server
SQL Server 2005
stored
table
t-sql
update
varchar
Browse All Tags