Microsoft KB Archive/196654

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:53, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Article ID: 196654

Article Last Modified on 6/11/2003



APPLIES TO

  • Microsoft SQL Server 7.0 Standard Edition



This article was previously published under Q196654

SUMMARY

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.

MORE INFORMATION

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 Examples

The 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



Additional query words: svc acct win 9x win95 win98 win9x

Keywords: kbhowto kbinfo KB196654