Edit

Share via


Broadcast a shutdown message from the command prompt

Applies to: SQL Server

This article describes how to broadcast a shutdown message in SQL Server by using the net send command. In the message, include the time the instance of SQL Server is going to stop, so that users can finish their tasks.

Broadcast a shutdown message

  1. From a command prompt, enter:

    net send /users "message"
    

    The /users option specifies that the message is sent to all users connected to the server.

Note

The net send command requires the messenger service to be running on both the sending and the receiving computers. The messenger service is disabled by default on Windows Server 2003. For information about net send, see the Windows documentation.

On your network, it might be more appropriate to contact users by e-mail or the telephone. To determine which users are currently connected to SQL Server, use the Activity Monitor. For information on the Activity Monitor, see Activity Monitor and Open Activity Monitor in SQL Server Management Studio (SSMS).