Skip to content

Latest commit

 

History

History
41 lines (31 loc) · 2.38 KB

broadcast-a-shutdown-message-command-prompt.md

File metadata and controls

41 lines (31 loc) · 2.38 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Broadcast a Shutdown Message (Command Prompt)
Find out how to use the net send command to broadcast a message in SQL Server. See how to determine which users are currently connected to SQL Server.
rwestMSFT
randolphwest
03/14/2017
sql
configuration
how-to
SQL Server, stopping
named instances [SQL Server], broadcasting shutdown messages
shutdown message broadcast
broadcasting shutdown message
command prompt [SQL Server], broadcasting shutdown messages
default instances [SQL Server], broadcasting shutdown messages
stopping SQL Server

Broadcast a Shutdown Message (Command Prompt)

[!INCLUDE SQL Server] This topic describes how to broadcast a shutdown message in [!INCLUDEssnoversion] by using the net send command. In the message, include the time the instance of [!INCLUDEssNoVersion] will be stopped so that users can finish their tasks.

To broadcast a shutdown message

  1. From a command prompt, enter:

    net send /users "message"

    The /users option specifies that the message be 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 may be more appropriate to contact users by e-mail or the telephone. To determine which users are currently connected to [!INCLUDEssNoVersion], use the Activity Monitor. For information on the Activity Monitor, see Activity Monitor and Open Activity Monitor (SQL Server Management Studio).

See Also

Start, Stop, Pause, Resume, Restart the Database Engine, SQL Server Agent, or SQL Server Browser Service