Microsoft SQL Server 2005 Administration
Best Practices

How to show all SQL servers on network?

 

Execute the following script in Query Editor to list all SQL servers on the network:

USE AdventureWorks
GO

exec xp_cmdshell 'SQLCMD -L';

GO

 

 

The Best SQL Server 2005 Training in the World
 
 
SQLUSA.com Home Page