To find all the available SQL Servers on the network that are broadcasting their existence.
Exec Master..XP_CMDSHELL 'SQLCMD -L'
First you have to enable XP_CMDSHELL from the Surface Area configuration before running this command.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment