Re: delete sql server registration in tsql

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@xxxxxxxxx) 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@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

.

Relevant Pages

  • RE: Transfer SQL 2000 Enterise Manager Client Server Registrations Fai
    ... I understand that you want to know how to have your SQL Server 2000 registered instances displayed in your Enterprise Manager which was newly installed on your ... Manually exporting registry key out and importing it to another machine is not a Microsoft support scenario. ...
    (microsoft.public.sqlserver.clients)
  • Re: fulltext search not working
    ... MSSearch service components or registry key &/or values at the server level ... with Microsoft SQL Server support. ... > the FTS component as the server is a production database and is hosted on ...
    (microsoft.public.sqlserver.fulltext)
  • Re: How to move system databases to new SAN drive in cluster serve
    ... See following article which contains information about Registry and editing ... Stop all services of virtual SQL Server by cluster administrator. ... On NODE1 change value of Key ... Start all services of virtual SQL Server by cluster administrator. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Performance Objects (sqlctr80.dll)
    ... reasons, such as Permission, Server Crash, Registry Modification and Virus. ... and "First Counter" values can vary between SQL Server ... Unload the SQL Server Counters ... In command line, execute "unlodctr MSSQLServer" (Without quotation, the ...
    (microsoft.public.sqlserver.setup)
  • Re: EM losing Server registrations in XP
    ... I will however give the registry tweak a go and see if it ... >Windows XP When Non-Domain User Password is Changed ... >Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)