|
|
Posted by Jennifer on 08/29/06 21:15
Totally awesome! Thanks! It took all of 2 seconds. Much much faster.
Erland Sommarskog wrote:
> Jennifer (J.Evans.1970@gmail.com) writes:
> > All I wanted to do was get those unregistered from the Enterprise
> > Manager so I don't have to see them. I was hoping I could select all of
> > them in Enterprise Manager, right click and delete the registration.
> > But it doesn't work like that. I don't really see myself doing that 400
> > times for each individual server. :) So I was just wondering if I could
> > do it with a loop or something along those lines from Query Analyser. I
> > see now that is really not possible.
>
> Nah, it's possible. But I doubt that it is any faster than to delete
> all those servers by hand. You would learn about registry hacking in
> the most inconvient way.
>
> Anyway, the brute method is to run RegEdit, and go to
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X
> and then go on a delete craze there.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|