When you use SQL Server 2000 Enterprise Manager to create
server groups and register servers, where is the information stored—in
the registry or a configuration file? For example, suppose I’ve created
100 server groups, and a total of 1000 servers. Assuming I’ve used Windows
authentication for registering all the servers, can I copy the information from
one client machine to another so that I don’t have to re-create the grouping
and registration?
AInformation about servers and server groups is stored in the registry key
HKEY_CURRENT_USER\Software\Microsoft\MicrosoftSQLServer\80\Tools\SQLEW\Registered
Servers X. You can export and import this registry key set by using regedit.exe.
This method isn’t supported, but should work for the scenario you describe.
—Richard Waymire
Program Manager Architect
Visual Studio Team System