Sending Messages

  • I am fairly new to SQL Server so bare with me...Is it possible for SQL Server to send a message to a user who is currently logged in? Can you schedule this message. The message is being sent to a USER and not an operator (who can receive messages via e-mail/pager)

  • A net send message can be sent to a user who is connected to MSSQLServer, by using enterprise manager. Look under management, current activity, process info, and then right click on the correct SPID.

  • Alternatively xp_sendmail can be used to send an email to anyone that can be resolved by the integrated mail services.

  • Thanks j.o.s. , ironically just after posting the message I found the info on net send. But your response is highly appreciated as I have been looking for a long time.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply