SQL Server Performance Forum – Threads Archive
Enterprise manager server configuration
Hi, I am new to sql server and have experience of nearly 1 year. I am facing one problem related to server configuration in enterprise manager as i have to configure around 70 server. Can we save the server configuration and export it to some other enterprise manager on different system. I know we can do this task in oracle and DB2 UDB but not quite sure about SQL Server 2000. Any info about this…….? Thanks, AnieYou can export the following registry file, save it as a a .reg file and then import it into another machine: \HKEY_CURRENT_USERSOFTWAREMICROSOFTMICROSOFT SQL SERVERTOOLSSQLEWREGISTERED SERVERS X hth,
Lesley Lesley Gilmour
Thanks Lesley,<br /><br />I gonna do it. I think it will work.<br /><br />[<img src=’/community/emoticons/emotion-3.gif’ alt=’‘ />)]<br />Thanks again<br />Anie
]]>