SQL Query Analyzer as a Intranet Messenger for the Admin

SQL Server has a extended stored procedure by name ‘xp_cmdshell’ that will do this.

It can be used as follows:



Exec master..xp_cmdshell 'NET SEND  message'

Ex: exec master..xp_cmdshell 'NET SEND 172.24.44.170 Hello?'
     Other Examples:  exec master..xp_cmdshell 'dir *.exe'……..


Note: The messenger service also needs to be up and running   in the destination system. If messenger service is stopped the above command will not work.

This stored procedure can be used to accomplish things that have to be done in command prompt like starting the SQL Service, etc..