sql server - DBCC TRACEON (1222) not setting status flag -


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

enter image description here


Comments