About Me

Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G

Tuesday, February 24, 2015

To enable ans disable the trace flags.

DBCC TRACESTATUS (1204, 1222);
GO

DBCC TRACEON (1222, -1);
DBCC TRACEON (1204, -1);

To disable the trace flag, you can use the below command.

DBCC TRACEOFF (1222, -1);
DBCC TRACEOFF (1204, -1);


No comments:

Post a Comment