DBCC TRACEON / DBCC TRACEOFF/ DBCC TRACESTATUS
DBCC TRACEON – Enable trace flags.
DBCC TRACEOFF – Disable trace flags.
DBCC TRACESTATUS – Display the status of trace flags.
–> Turn flag on for only the session level
DBCC TRACEON (1222)
DBCC TRACEON (1205,1222)
GO
–> Turn flag on globally at server for all the sessions
DBCC TRACEON (1222, -1)
GO
— >Turn flag off
DBCC TRACEOFF (1222);
GO
–> Show flag status
DBCC TRACESTATUS (1205,1222)
DBCC TRACESTATUS (-1)
