Sunday, March 11, 2012

Add Startup DBCC Traceon (1204)

I need to add the DBCC Traceon (1204) to my SQL Server
startup. Everytime my server is rebooted I have to
reapply the DBCC Traceon (1204) statement.
I would this to applied each time my server is rebooted.
Please help me completing this task.
Thank You,
DanYou could do this using Enterprise Manager. See
http://vyaskn.tripod.com/administration_faq.htm#q14 for more info.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:14daf01c3fa1f$d06a1850$a001280a@.phx.gbl...
I need to add the DBCC Traceon (1204) to my SQL Server
startup. Everytime my server is rebooted I have to
reapply the DBCC Traceon (1204) statement.
I would this to applied each time my server is rebooted.
Please help me completing this task.
Thank You,
Dan

No comments:

Post a Comment