devxlogo

Use ISQLW for Messenger Service in an Intranet

Use ISQLW for Messenger Service in an Intranet

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.

devx-admin

Share the Post: