Before you stop Microsoft® SQL Server™, you can broadcast a message to warn users of an impending shutdown. In the message, you can include the time SQL Server will be stopped so users can finish their tasks.
To broadcast a shutdown message
SHUTDOWN | sp_lock |
SQL Server Service Manager | sp_who |