Setting SQL Server Startup Options 

Use

When the SQL Server is started, parameters are read from the Windows NT 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.

Procedure

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 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.

Confirm your entries with OK.

To get information about available parameters, search for the topic "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