Re: delete sql server registration in tsql
- From: "Jennifer" <J.Evans.1970@xxxxxxxxx>
- Date: 29 Aug 2006 14:15:52 -0700
Totally awesome! Thanks! It took all of 2 seconds. Much much faster.
Erland Sommarskog wrote:
Jennifer (J.Evans.1970@xxxxxxxxx) 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@xxxxxxxxxxxxx
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
.
- References:
- delete sql server registration in tsql
- From: J . Evans . 1970
- Re: delete sql server registration in tsql
- From: Erland Sommarskog
- Re: delete sql server registration in tsql
- From: Jennifer
- Re: delete sql server registration in tsql
- From: Erland Sommarskog
- delete sql server registration in tsql
- Prev by Date: Re: grant access to extended properties
- Next by Date: Re: Import ASCII Data
- Previous by thread: Re: delete sql server registration in tsql
- Next by thread: grant access to extended properties
- Index(es):
Relevant Pages
|
