If you are running the windows 98/95 version of SQL Server, then you can use the Windows 98/95 specific scm.exe utility to stop and start SQL Server. The scm.exe utility actually mimics Windows NT commands, such as net start and net stop for starting and stopping the services. For example, to use scm.exe to stop the SQL Server, type:
scm -action 6 -service mssqlserver
On the other hand, to start the SQL Server service, type:
scm -action 1 -service mssqlserver
You can find scm.exe utility in the \Mssql7\Binn folder when you install SQL Server 7.0 on a Windows 95/98 computer.
If you have a hot tip and we publish it, we'll pay you. However, due to accounting overhead we no longer pay $10 for a single tip submission. You must accumulate 10 acceptable tips to receive payment. Be sure to include a clear explanation of what the technique does and why it's useful. If it includes code, limit it to 20 lines if possible.
Submit your tip here.
