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
3 comments
Hide comments
