EM Surprise | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

EM Surprise

Hi Experts,[^]<br />Whenever I first run EM it shows all the instances of registered SQL Server.<br />How EM comes to know the registered instances.[?]<br />How EM loads them.[<img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />]
HKEY_CURRENT_USERSoftwareMicrosoftMicrosoft SQL Server80ToolsSQLEWRegistered Servers X<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />–<br />Frank Kalis<br />SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />

SQL BOL says: – When you run SQL Server Enterprise Manager for the first time, it automatically registers all instances of a local SQL Server. However, if you have one instance of SQL Server registered, and then install more instances of SQL Server, only the original instance of SQL Server will be registered. You can launch the Register Server Wizard or use the Registered SQL Server Properties dialog box to register additional servers. The Registered SQL Server Properties dialog box is populated with the names of all local instances of SQL Server.
if you have some time to R&D check these: – http://www.nirsoft.net/utils/empv.html
http://exchange.manifold.net/manifold/manuals/5_userman/mfd50Creating_an_Enterprise_Server.htm Deepak Kumar –An eye for an eye and everyone shall be blind
those are saved in the registry
HKEY_CURRENT_USERSoftwareMicrosoftMicrosoft SQL Server80ToolsClientPrefServers

Thanks Frank [8D] Deepak Kumar –An eye for an eye and everyone shall be blind
Thanx a lot guys,
This Forum is simply great,
Here i feel we can get answer to any question.