Setting SQL Server Startup Options


When the SQL Server is started, parameters are read from the Windows Registry that influence how it is started. In the course of your administrative work, you may need to modify or check these parameters using the Enterprise Manager.



       1.         In the Enterprise Manager, select the server and then choose Action ®Properties.

The Server Properties dialog box opens.

       2.      On the General tab, choose the Startup Parameters button.

The Startup Parameters box appears. It shows all the currently set startup parameters.

       3.      To add a parameter, enter the name in the Parameter field and choose Add. To remove a parameter, select it and choose Remove.

       4.      Confirm your entries with OK.

To get information about available parameters, search for sqlservr application in the MS SQL Server Books Online.

In the Registry, the parameters are located in:

HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer/ MSSQLServer/parameters/

If you have multiple instances the parameters are located in:

HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/ <Instance Name>/parameters/