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