Changes in EM registration

  • Hi to all:

    I have several SQL Server instances registered in my EM with the sa login and pass. We have to change the pass of the sa in all of our instances, and I want to know if there is a way to register or change a registration with T_SQL. I trace with profiler, but could'n see anything that would help me.

    thanks in advanced

  • The servers registered in EM are stored in the registry at the following key,

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

    It's a binary value so you probably wouldn't want to spend the time to change it there

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply