SQL Server 7.0 startup parameters

SQL Server 7.0 includes several startup parameters that you can use to control how the server starts up. You can use these parameters from the command line or by modifying your server's Registry. To use the parameters from the command line, first stop the MSSQLServer service by using either Control Panel or the net stop command. Next, restart your server from the Command Prompt by running the command sqlservr along with your optional parameters. To use the parameters in your server's Registry, edit the following Registry key:  

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer\Parameters

Add any optional parameters you want to run when the server starts by adding them as values. Name the value SQLArgx (where x equals the first number that is not currently in use). By default, you should see SQLArg0, SQLArg1, and SQLArg2, so use SQLArg3 as the name of the first optional parameter value. Some of the optional parameters you can add include: 

-c  Use to start SQL Server without registering its services with the Services Control Manager. This increases the speed of startup, but you won't be able to stop and start the services within the Services icon in Control Panel. 

-f Use to start SQL Server in minimal configuration mode.

-m Use to start SQL Server in single-user mode.

-x Use to prevent SQL Server from calculating the CPU time and cache-hit statistics. This parameter maximizes the performance of SQL Server but decreases the amount of information you can obtain about your server's performance. 

SQL Index

Main Index