how to do this from Enterprise Manager).
Thanks!
Jennifer(J.Evans.1970@.gmail.com) writes:
Quote:
Originally Posted by
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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||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:
Quote:
Originally Posted by
(J.Evans.1970@.gmail.com) writes:
Quote:
Originally Posted by
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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I could be totally wrong here but . . .
As far as I know there is a MMC folder that has the data you want.
<drive>:\Documents and Setting\<your logon name>\Application
Data\Microsoft\MMC
Adrian
Jennifer wrote:
Quote:
Originally Posted by
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:
Quote:
Originally Posted by
>(J.Evans.1970@.gmail.com) writes:
Quote:
Originally Posted by
>>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/pr...oads/books.mspx
>Books Online for SQL Server 2000 at
>http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||Adrian,
Thank you for the response. I found the folder and while the files did
look interesting, they did not appear to have the info in there.
Thanks,
Jennifer
abc wrote:
Quote:
Originally Posted by
I could be totally wrong here but . . .
>
As far as I know there is a MMC folder that has the data you want.
>
<drive>:\Documents and Setting\<your logon name>\Application
Data\Microsoft\MMC
>
>
Adrian
>
>
Jennifer wrote:
Quote:
Originally Posted by
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:
Quote:
Originally Posted by
(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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
|||Jennifer (J.Evans.1970@.gmail.com) writes:
Quote:
Originally Posted by
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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Totally awesome! Thanks! It took all of 2 seconds. Much much faster.
Erland Sommarskog wrote:
Quote:
Originally Posted by
Jennifer (J.Evans.1970@.gmail.com) writes:
Quote:
Originally Posted by
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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
No comments:
Post a Comment