Manage Startup Parameters in SQL Server 2005

DenSter

Okay so I spent a long time figuring this out... In the SQL Server 2000 Enterprise Manager the startup parameters are right on the server properties, so it was frustrating to try and figure out where it is in SQL Server 2005, and when I finally did figure it out I figured this might help someone.

Open Start -> SQL Server -> Configuration Tools -> Configuration Manager

In there click on SQL Server 2005 Services, right click your SQL Server instance, and select Properties. You'll find startup parameters on the advanced tab. You can add parameters here, make sure you separate them with a semicolon ( ; ) and apply. They take effect after you restart the service.

Waldo

What a coincidence ... I've been looking for it myself today :whistle: .
I found that thanks to Scott Frapier on this thread:
http://www.mibuso.com/forum/viewtopic.p ... 1&start=15

kine

Everybody wants to set trace flag 4616... 8)

DenSter

That's why I posted this information since NAV 5.0 won't even open the database without the flag.

ara3n

It's in documentation pdf file on the CD btw.