DBCC TRACEON (3604,1)--turn ON
DBCC TRACEON (3605,1)----turn ON
DBCC TRACEOFF(3604, -1) ---turn OFF
GO
DBCC TRACEOFF(3605, -1) --turn OFF
GO
there are advantages and dis advantages of suing above
Disadvantages file gets huge
advantages below:
http://sql-articles.com/articles/general/day-1-trace-flag-3604-3605/
DBCC TRACEON (3605,1)----turn ON
DBCC TRACEOFF(3604, -1) ---turn OFF
GO
DBCC TRACEOFF(3605, -1) --turn OFF
GO
there are advantages and dis advantages of suing above
Disadvantages file gets huge
advantages below:
http://sql-articles.com/articles/general/day-1-trace-flag-3604-3605/
No comments:
Post a Comment