Enable Trace Flag

Hi All
How do I go about enabling the trace flag 1204 in SQL Server 2005. In SQL
Server 2000 I could enable this trace flag by updating the Startup Parameters
however I haev not been able to locate this option in SQL Server 2005.
Thanks
David
Its global trace flags and you must set at the server level
DBCC TRACEON (TF-1222 )
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d373298b-f6cf-458a-849d-7083ecb54ef5.htm
"David" <David@.discussions.microsoft.com> wrote in message
news:E572CF39-B512-41DC-A723-059CA9096C69@.microsoft.com...
> Hi All
> How do I go about enabling the trace flag 1204 in SQL Server 2005. In SQL
> Server 2000 I could enable this trace flag by updating the Startup
> Parameters
> however I haev not been able to locate this option in SQL Server 2005.
> Thanks
|||Hi David
It's tricky to find in SQL 2005...
You can use SQL Server Configuration Manager, right click your SQL Server
Service and choose Properties.
Then you need the Advanced Tab, and add -T1204 to the list of startup
parameters. Make sure you separate it from other startup parameters with
semicolon (;) and don't leave a space.
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"David" <David@.discussions.microsoft.com> wrote in message
news:E572CF39-B512-41DC-A723-059CA9096C69@.microsoft.com...
> Hi All
> How do I go about enabling the trace flag 1204 in SQL Server 2005. In SQL
> Server 2000 I could enable this trace flag by updating the Startup
> Parameters
> however I haev not been able to locate this option in SQL Server 2005.
> Thanks
|||Oops, I hadn't seen that Tibor beat me to it... just do what he says!
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eSe%23IlgTHHA.5108@.TK2MSFTNGP06.phx.gbl...
> Hi David
> It's tricky to find in SQL 2005...
> You can use SQL Server Configuration Manager, right click your SQL Server
> Service and choose Properties.
> Then you need the Advanced Tab, and add -T1204 to the list of startup
> parameters. Make sure you separate it from other startup parameters with
> semicolon (;) and don't leave a space.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> http://sqlblog.com
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:E572CF39-B512-41DC-A723-059CA9096C69@.microsoft.com...
>