Article ID: 196654 - View products that this article applies to.
This article was previously published under Q196654
If you have SQL Server 7.0 or the Microsoft Data Engine (MSDE) 1.0 installed on a computer that is running Microsoft Windows 95 or Microsoft Windows 98, you may want to start and stop SQL Server or the MSDE services from a command prompt, or from a batch file (similar to using the net start and the net stop commands that are available on computers that are running Microsoft Windows NT).
SQL Server 7.0 and MSDE 1.0 come with a utility named Scm.exe that you can use for this purpose. This utility is located in the Mssql7\Binn folder. However, note that Scm.exe is not as comprehensive as the net commands, because it only mimics the functionality of the net commands for the services installed by SQL Server. Also, note that you cannot use Scm.exe to start the SQLServerAgent service on Windows 95 or Windows 98, although you can use the utility to start the MSSQLServer service.
For a complete list of the arguments used with the Scm.exe utility, open a command prompt, type scm, and then press ENTER.
Scm.exe Utility ExamplesThe following are examples that use the Scm.exe utility to start, stop, and modify the MSSQLServer Service:
Start the MSSQLServer Service
scm -Action 1 -Service mssqlserver
Stop the MSSQLServer Service
scm -Action 6 -Service mssqlserver
Modify the MSSQLServer Service Startup Account to the System Account
scm -Action 7 -Service mssqlserver -SvcAccount LocalSystem
Article ID: 196654 - Last Review: June 11, 2003 - Revision: 3.1
Contact us for more help