Start Up Options in SQL Server 2005

A reader recently asked how to access the start up options in SQL Server 2005.  In SQL Server 2000, they were able to access it through Enterprise Manager.  In SQL Server 2005, you can do so from the SQL Server Configuration Manager.  As you can see from the image below, you can right click on the service, select properties and then on the Advanced tab, you can get to the startup parameters for that instance – the ones shown in the image below are the default ones:

Besides the default ones, the most commonly used ones are the “-g” or “-T” options.  You can read more about all the   startup options that are available in SQL Server 2005 at this MSDN article here.