i trying set deadlock flags in sql 2008 r2, when run command
dbcc traceon (1222)
i no errors , says completed dbcc traceon (1222)
, when check status of flag not being set
dbcc tracestatus (1222)
.
is there way set this? why wouldn't work?
thanks!
dbcc traceon('someflag')
sets trace flag @ session level , once session closed,trace flag no longer active
to set traceflags globally use command..
dbcc traceon('someflag',-1)
to view trace flags set globally use this..
dbcc tracestatus(-1)
trace flags cleared once sqlserver restarted.you need create them @ startup of sqlserver,if want them persisted
Comments
Post a Comment