SQL Query Analyzer as a Intranet Messenger for the Admin
By [)ia6l0 iii
ODBC Drivers for QuickBooks, Salesforce, SAP, MSCRM, SharePoint … Free Trial!
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
It can be used
'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
the destination system. If messenger service
stopped the above command will not work.
This stored procedure can be used to accomplish things that have to be done
command prompt like starting the SQL Service, etc..