SQL Server

Active Trace Flags

Posted on by WARDY IT Solutions

If you ever need to identify the Trace Flags that are currently active you can simply execute the TSQL Statement below. The output will return each of the trace flags that are currently enabled.

DBCC TRACESTATUS(-1)

WARDY IT Solutions

WARDY IT Solutions - Australia's leading SQL Server consultants, trainers and Business Intelligence specialists. WARDY IT Solutions has established itself amongst the top solution providers in SQL Server technologies providing solutions for customers throughout Asia Pacific.