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.
ThanksDavid
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|||Easiest way (IMO) is to modify the registry. For my instance, the path is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.3\MSSQLServer\Parameters
So you now can add -T1204 as an REG_SZ SQLArg3 (or whatever your next number is).
You can also use the SQL Server Configuration Manager tool. Make sure you seperate this trace flag
with semi-colon, though (check the registry for correctness).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"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...
>> 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...
Yes, but you explained it better. First time I tried using Configuration Manager, I didn't get the
semi-colon thing. So I think I forced a line-feed (something like shift-enter). This messed up the
third option (ldf file), so the instance wouldn't start. When I checked the registry, I understood
what had happen.
I'd like it if Configuration Manager exposed the Parameter option more explicit (or even SSMS), and
if each option is actually parsed (like I believe EM do).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uVclttgTHHA.3996@.TK2MSFTNGP04.phx.gbl...
> 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...
>> 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
>>
>|||Yes, I still find it hard to use the Config Manager for this purpose. I wish
they made it easier to add a startup flag.
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%238TTjNiTHHA.4872@.TK2MSFTNGP03.phx.gbl...
>> Oops, I hadn't seen that Tibor beat me to it...
> Yes, but you explained it better. First time I tried using Configuration
> Manager, I didn't get the semi-colon thing. So I think I forced a
> line-feed (something like shift-enter). This messed up the third option
> (ldf file), so the instance wouldn't start. When I checked the registry, I
> understood what had happen.
> I'd like it if Configuration Manager exposed the Parameter option more
> explicit (or even SSMS), and if each option is actually parsed (like I
> believe EM do).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:uVclttgTHHA.3996@.TK2MSFTNGP04.phx.gbl...
>> 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...
>> 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
>>
>>
>