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 172.24.44.170 Hello?'
Other Examples: exec master..xp_cmdshell
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 (685 Views)