• chuckh 3191 (12/14/2010)


    I'm trying to remember. Do you have to turn back on DBCC TRACEON each time you restart the instance?

    yes.

    from the article -

    It is important to note that setting trace flags this way will only work until the next time SQL Server is restarted. If you want to make sure your trace flags are always set this way, you can edit the startup options of SQL Server by using the -T switch or creating a SQL Agent job to run that code when the Agent starts.