Transact-SQL Desk Reference

5.3. SERVER SHUTDOWN

5.3.1. MSS 2000

Use the following steps to gracefully shut down an SQL Server in MSS 2000.

1.	Broadcast a shutdown message. (See BOL: Broadcasting a Shutdown Message). Execute the following in a Windows Command Window (DOS window). C:\> net send /users "SQL Server AMY is going down for maintenance in 20 minutes. Please finish work and disconnect asap." Note: net send /user msg -- sends msg to all users connected to the sending host. net send /domain msg -- sends msg to all users in the domain
2.	Open an Enterprise Manager and Query Analyzer as sa. This must be done before pausing the server since you can't connect after pausing.
3.	PAUSE the SQL Server. You can use Enterprise Manager or Service Manager. According to Books ...