|
|
Posted by Erland Sommarskog on 08/29/06 21:09
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]
|