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:
- Open SQL Server Configuration Manager
- Select SQL Server 2005 Services
- Right click the SQL Server service and select Properties
- Select the Advanced tab
- 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.
ie.
… 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