to retrive the names of the registered names of server on a particular server

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 Administration (2000)

to retrive the names of the registered names of server on a particular server

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-21 : 09:13:26

aparna writes "dear SQL team

please tell me how do we retrive the names of the registered servers from a server

please help

aparna
(aparnavkamath@hotmail.com)"

Jay99

468 Posts

Posted - 2002-03-21 : 10:01:38

quote:

...registered servers...

What's that? Do you mean Remote Servers? Maybe Linked Servers? Do you mean the names of the servers you have 'registered' in your Enterprise Manager?

Jay
<O>

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-03-21 : 10:51:08

sp_helpserver can get you information on this, it is documented in Books Online.

pandurang123
Starting Member

1 Post

Posted - 2002-03-22 : 00:25:20

Yes, I want name of all the servers which are registered in my enterprise manager. I have already used sp_helpserver but it did not retrive the names of the registered servers

I am having sql server 2000 and one registered server (SQL 7.0)

Is it due to the other version i did not get the name of the other registered server

Please Help
Thanx in advance

Pandurang D. Galande
Manas Solutions Pvt. Ltd

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-03-22 : 01:17:01

The registered servers in Enterprise Manager are not actually stored on the database server. It is stored as a client setting for Enterprise Manager for that user.

I found a list in

HKEY_CURRENT_USER\software\mirosoft\Microsoft SQL Server\80
\Tools\SQLEW\Registered Servers X\SQL Server Group

You would need some code to read the registry to use this in a program.

Damian

sspear
Starting Member

1 Post

Posted - 2002-03-22 : 03:17:09

Try the following VbScript (I'm no VbScript guru, however). DMO is
documented in sqldmo80.hlp

[Pre]
'22-Mar-02 Show Registered Servers using Sql-DMO
Set oFs = Wscript.CreateObject("Scripting.FileSystemObject")
Set oOut = oFs.CreateTextFile("3.tst", True)
Set oSQLServerDMOApp = CreateObject("SQLDMO.Application")

Set serverGroups = oSQLServerDMOApp.ServerGroups
For sgI = 1 to serverGroups.Count
Set serverGroup = serverGroups.Item(sgI)
oOut.WriteLine "Server Group Name: "+serverGroup.Name
Set registeredServers = serverGroup.RegisteredServers
For rsI = 1 to registeredServers.Count
Set registeredServer = registeredServers.Item(rsI)
With registeredServer
oOut.WriteLine "Registered Server Name: "+.Name
oOut.WriteLine "Login: "+.Login
oOut.WriteLine "Password: "+.Password
oOut.WriteLine "PersistFlags: " & .PersistFlags
oOut.WriteLine "SaLogin: " & .SaLogin
oOut.WriteLine "Use Trusted Connection: " & .UseTrustedConnection
oOut.WriteLine "VersionMajor: " & .VersionMajor
oOut.WriteLine "VersionMinor: " & .VersionMinor
End With 'registeredServer
Next 'registeredServers
Next 'serverGroups

[/Pre]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources