How to list all SQL Server Instance Running in Local Network:
Some time you need to see the List of other running SQL server on your network. It is so simple and easy to call from other application also.
See the example:
– ######### Query
EXEC master..xp_cmdshell ‘osql -L’
– ############ Result
NULL
Servers:
(local)
MAIL_SERVER
[...]
Filed under: SQL Server Instance Running | Tagged: How to list all SQL Server Instance Running in Local Network:, Instance Running, MS SQL server, MSSQL tips, MSSQL tricks, Raghunath Bhandari | Leave a Comment »
