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);
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