SQL SERVER – Trace Flags – DBCC TRACEON | Journey to SQL Authority with Pinal Dave

Trace flags are valuable tools as they allow DBA to enable or disable a database function temporarily. Once a trace flag is turned on, it remains on until either manually turned off or SQL Server restarted. Only users in the sysadmin fixed server role can turn on trace flags. If you want to enable/disable Detailed… Continue Reading...

Source: SQL SERVER – Trace Flags – DBCC TRACEON | Journey to SQL Authority with Pinal Dave