Broadcast a Shutdown Message (Command Prompt)
Applies To: SQL Server 2016
This topic describes how to broadcast a shutdown message in SQL Server 2016 by using the net send command. In the message, include the time the instance of SQL Server will be stopped so that users can finish their tasks.
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
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 SQL Server, use the Activity Monitor. For information on the Activity Monitor, see Activity Monitor and Open Activity Monitor (SQL Server Management Studio).