Enabling a Trace Flag

In SQL Server 2000 setting a trace flag was really obvious. In Enterprise Manager you could right click on a Server and select properties and then add a Startup Parameter. In SQL Server 2005 the process to set a trace flag is not quite as obvious, as the Startup Parameters are not set in SSMS but in SQL Server Configuration Manager.

To set a trace flag in SQL Server 2005 you need to follow the steps below:

  1. Open SQL Server Configuration Manager
  2. Select SQL Server 2005 Services
  3. Right click the SQL Server service and select Properties
  4. Select the Advanced tab
  5. Edit the Startup Parameters property

The thing to note is that you need to make sure that you separate the Trace Flag from other startup parameters with a semicolon (;) and don’t leave a space.


… mastlog.ldf;-T1204

The following registry key lists all of the SQL Server Startup Parameters that have been set:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.3\MSSQLServer\Parameters