|
|
Posted by abc on 08/29/06 19:48
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:
> 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]
|