|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Deleting old servers still listed in Query Analyzer ???????????????I can use the Client Network Utility (CNU) from SQL 2000 to create/delete
aliases. But when I 1st run Query Analyzer (QA)... it shows a list of some old servers we used to have... long ago. How do I delete from that list? (The old servers have already been removed from the CNU alias list... but they seem to stay listed in QA forever.) They have nothing to do with each other. Any registrations you did in QA or
EM you will have to manually delete them from the registrations by right clicking and choosing Delete. -- Show quoteAndrew J. Kelly SQL MVP ""A_Michigan_User"" <Michigan_RE_M***@ameritech.net> wrote in message news:%23gKQ7lwOGHA.3944@tk2msftngp13.phx.gbl... >I can use the Client Network Utility (CNU) from SQL 2000 to create/delete >aliases. > > But when I 1st run Query Analyzer (QA)... it shows a list of some old > servers we used to have... long ago. > > How do I delete from that list? > > (The old servers have already been removed from the CNU alias list... but > they seem to stay listed in QA forever.) > > > > They have nothing to do with each other. I thought I *HAD TO* add them with CNU... then they appeared as "available" in QA and EM. No? Show quote "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:eP%237NMyOGHA.1312@TK2MSFTNGP09.phx.gbl... > They have nothing to do with each other. Any registrations you did in QA > or EM you will have to manually delete them from the registrations by > right clicking and choosing Delete. > > -- > Andrew J. Kelly SQL MVP > > > ""A_Michigan_User"" <Michigan_RE_M***@ameritech.net> wrote in message > news:%23gKQ7lwOGHA.3944@tk2msftngp13.phx.gbl... >>I can use the Client Network Utility (CNU) from SQL 2000 to create/delete >>aliases. >> >> But when I 1st run Query Analyzer (QA)... it shows a list of some old >> servers we used to have... long ago. >> >> How do I delete from that list? >> >> (The old servers have already been removed from the CNU alias list... but >> they seem to stay listed in QA forever.) The CNU just allowed you to alias them. Then maybe you can see them thru
the alias but that is not a requirement to register a server. You just need the name or IP address of the server and it has to be available on the right port, 1433 by default. -- Show quoteAndrew J. Kelly SQL MVP ""A_Michigan_User"" <Michigan_RE_M***@ameritech.net> wrote in message news:eqFg7jlRGHA.2156@tk2msftngp13.phx.gbl... >> They have nothing to do with each other. > > I thought I *HAD TO* add them with CNU... then they appeared as > "available" in QA and EM. > > No? > > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:eP%237NMyOGHA.1312@TK2MSFTNGP09.phx.gbl... >> They have nothing to do with each other. Any registrations you did in QA >> or EM you will have to manually delete them from the registrations by >> right clicking and choosing Delete. >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> ""A_Michigan_User"" <Michigan_RE_M***@ameritech.net> wrote in message >> news:%23gKQ7lwOGHA.3944@tk2msftngp13.phx.gbl... >>>I can use the Client Network Utility (CNU) from SQL 2000 to create/delete >>>aliases. >>> >>> But when I 1st run Query Analyzer (QA)... it shows a list of some old >>> servers we used to have... long ago. >>> >>> How do I delete from that list? >>> >>> (The old servers have already been removed from the CNU alias list... >>> but they seem to stay listed in QA forever.) > > "A_Michigan_User" wrote: For QA, the servers are stored here in the registration database:> I can use the Client Network Utility (CNU) from SQL 2000 to > create/delete aliases. > > But when I 1st run Query Analyzer (QA)... it shows a list of some old > servers we used to have... long ago. > > How do I delete from that list? > > (The old servers have already been removed from the CNU alias list... > but they seem to stay listed in QA forever.) HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\Client\PrefServers You can remove the pairs you do not need - carefully. I don't know how to remove servers from the QA drop-down list in the connection dialog other than by editing the regdb. I see different servers listed in QA than I have for SQLEM, so removing the server from SQLEM does seem like it will work in QA. -- David Gugick - SQL Server MVP Quest Software  |
|||||||||||||||||||||||
Other interesting topics