SQL Query Analyzer as a Intranet Messenger for the Admin

One of the ways the SQL Query Analyzer can be used is as the intranet messenger

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 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..
By [)ia6l0 iii   Popularity  (856 Views)