dcollins2010
asked on
SQL command to send infomessage to users
Is there a command in MSSQL that will allow me to send a message to connected users? I see that the SqlConnection class in C# has an InfoMessage event, I just need to be able to send the message from the server in a stored procedure. I'm guessing this is pretty easy, but I tried googling this and all I found were people trying to send emails from stored procedures.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You will have to write your own code to do that in your application. From SQL alone, the best you can do is add T-SQL code to send an email notifying the change.
ASKER