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.

--
Andrew J. Kelly  SQL MVP


""A_Michigan_User"" < Michigan_RE_M0VE@ame
ritech.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:
> 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.)

For QA, the servers are stored here in the registration database:
 HKEY_CURRENT_USER\So
 ftware\Microsoft\Mic
rosoft SQL
 Server\80\Tools\Clie
nt\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

> 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@shadh
awk.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_M0VE@ame
ritech.net> wrote in message
> news:%23gKQ7lwOGHA.3944@tk2msftngp13.phx.gbl... 

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.

--
Andrew J. Kelly  SQL MVP


""A_Michigan_User"" < Michigan_RE_M0VE@ame
ritech.net> wrote in message
news:eqFg7jlRGHA.2156@tk2msftngp13.phx.gbl... 
>
> I thought I *HAD TO* add them with CNU... then they appeared as
> "available" in QA and EM.
>
> No?
>
>
> "Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
> news:eP%237NMyOGHA.1312@TK2MSFTNGP09.phx.gbl... 
>
>