Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Server Group or Servers

Author  Topic 

obed22
Starting Member

2 Posts

Posted - 2007-09-27 : 15:19:32
Is there any way or store procedure to Lists all SQL Server Group or Servers that reside in an instance of Microsoft SQL Server?

Like sp_databases that show databases that reside in one SQL Server?

Thank you!!

Koji Matsumura
Posting Yak Master

141 Posts

Posted - 2007-09-27 : 21:26:43
What is an SQL Server Group?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-28 : 00:39:12
There is no other sql servers reside in sql instance. If you like to list all related remote servers, use sp_helpserver. If you like to see all server groups defined and servers registered in em, check registry.
Go to Top of Page
   

- Advertisement -