Reputation:

SQL Server - To get all connected server names

In SQL Server 2000/2005, I want to get the names of all connected servers. How do I do this?

Upvotes: 2

Answers (3)

John Sansom

Reputation: 41889

If you want to search your entire network in order to retrieve comprehensive information for all SQL Server Instances in your topology you can use the freely available Quest Discovery Wizard.

Quest Discovery Wizard for SQL Server

Upvotes: 0

Lieven Keersmaekers

Reputation: 58491

In addition to sp_helpserver, you can get additional information from sys.servers.

SELECT * FROM sys.servers

Upvotes: 1

Stanislav Kniazev

Reputation: 5488

exec sp_helpserver

Upvotes: 2

SQL Server - To get all connected server names

Answers (3)

Related Questions