Message to all logged on users

• Sam Shiell

  Ten Centuries

  Points: 1373

  More actions

  November 24, 2004 at 4:39 am

  #162723

  Hi

  I have a vague recollection that years ago when I was a DBA there was a simple way to send a message to all logged on users of a server (so you could say things like "Server is shutting down in 2 minutes. Log out now"), but can't remember how to do it and can find nothing in BOL

  Any ideas, or have I just remembered this incorrectly.

  Cheers

  Sam

   

   

• Yvan Bouchard

  SSCrazy

  Points: 2506

  More actions

  November 25, 2004 at 5:15 am

  #531518

  Hi Sam.

  From BOL...

  How to broadcast a shutdown message (Command Prompt)

  To broadcast a shutdown message

  • From a command prompt, enter:

    net send /users "message"

    For example:

    net send /users "SQL Server is going down in 20 minutes. Disconnect within 15 minutes."

    

    Note  The shutdown message can be broadcast only if an instance of Microsoft® SQL Server™ is running on Microsoft Windows NT® 4.0 or Windows® 2000. The users option specifies that the message be sent to all users connected to the server. For information about other net send options, see the Windows NT 4.0 and Windows 2000 documentation.

   

  ...or when you detach the database and you clear the connections, at that time you can also advise users.

• Sam Shiell

  Ten Centuries

  Points: 1373

  More actions

  November 29, 2004 at 7:23 am

  #531716

  Thanks Yvan

  Knew it had to be something

  Sam