Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Intermediate
Apr 12, 2002

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.
Madhusudana Naidu
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date