|
|
Posted by Jennifer on 08/29/06 13:33
Erland,
Thanks for the reply. Just to be clear, though. I wasn't trying to be
sneaky and manipulate registry on other machines. ;) I was trying to
unregister servers on my own computer. We have about 400 different
servers where I work - each one is the SQL server for a restaurant. I
have every one of them registered on my computer so that if I need to,
I can get to their database. Well....a lot of changes were made
recently, and now the user name/password that is associated with said
servers is not valid. 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.
Thanks,
Jennifer
Erland Sommarskog wrote:
> (J.Evans.1970@gmail.com) writes:
> > Is there any way in tsql to delete a sql server registration? (I know
> > how to do this from Enterprise Manager).
>
> There are undocumented extended stored procedures to manipulate the
> registry. However, starting with SQL 2000 SP4, they were changed to
> permit changes only within the tree of the SQL Server instance, if
> memory serves.
>
> In any case, I would say that it does not really make sense. Enterprise
> Manager is a client, and SQL Server is a server. A server sends data to
> its clients on requests. It does not send requests to the clients.
>
> If you want manipulate the registry on remote machines, Windows offers
> more direct ways to do this, and that is far better than sneaking around
> through SQL Server.
>
>
> --
> 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]
|