To stop the default instance of SQL Server
- From a command prompt, enter:
net stop mssqlserver
Note Stopping a default instance of Microsoft® SQL Server™ using SQL Server Enterprise Manager or the net stop mssqlserver command causes SQL Server to perform a checkpoint in all databases. Then a SHUTDOWN WITH NOWAIT is done to flush all committed data from the data cache and to stop the server immediately. Stopping a default instance of SQL Server from the command prompt works only if you are running Microsoft Windows NT® 4.0 or Windows® 2000.