|
|
Posted by Jennifer on 08/29/06 20:53
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:
> 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]
|