It’s possible to send messages from one system to another system in an Intranet by using ‘xp_cmdshell’ extended stored procedure in MS SQL Server. The usage of this procedure can be as follows:
Exec master..xp_cmdshell 'NET SEND message'Ex: exec master..xp_cmdshell 'NET SEND prodmaster Hi, How R U?' Note: The messenger service also needs to be started in the destination system. If messenger service is stopped the above command will not work.
