Re: Using Query Analyzer with SQL 2005

Mike,

8.00.2026 was a beta version of SP4. There were many complaints
about Query Analyzer not connecting to 2005 (originally an intentional
post-sp3a change), and the planned change (disable QA connections
to 2005) was undone for the release of SP4.

See http://www.aspfaq.com/sql2000builds.asp. You may need to
download the final SP4.

SK

Mike C# wrote:

Weird. I have SP 4 installed, so I figured I'd reinstall. Still coming up 8.00.2026. Strange. Oh well...

"Steve Kass" <skass@xxxxxxxx> wrote in message news:eVZoS8LhGHA.4708@xxxxxxxxxxxxxxxxxxxxxxx


Mike,

What version of SQL Server 2000 Query Analyzer are you using? Go to
Help | About ... and check the version. 8.00.2039 is the current version.

If I remember correctly, Query Analyzer did not work against 2005 at
some point before SQL Server 2000 Service Pack 4. Maybe you need
to upgrade your 2000 installation.

Steve Kass
Drew University

Mike C# wrote:



Just tried it over here, wouldn't connect. I'm running SQL 2005 Standard with SP1 installed. Maybe they disabled this with SP1?

"Unable to connect to SQL Server [name]: To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)"

"Keith Kratochvil" <sqlguy.back2u@xxxxxxxxxxx> wrote in message news:%235YsBQDhGHA.1204@xxxxxxxxxxxxxxxxxxxxxxx



Yes. Query Analyzer connects to SQL Server 2005. I have not discovered any issues with this method.

--
Keith Kratochvil


"Richard West" <RichardWest@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:EBE27DA3-7105-44C9-8C1F-77D667A86B37@xxxxxxxxxxxxxxxx



I'm about to install and roll out SQL Server 2005.

One question that I have though: Can I still use Query Analyzer with SQL
Server 2005?

I really like how simple the interface is to do quick and dirty ad-hoc
queries. Also, assuming this will work, is there a version of Query Analyzer
that comes with SQL Server 2005 that I can contiue to install on my client
systems, or will I always need to keep a copy of SQL Server 2000 to install
from?

The Studio looks nice, but just a little overkill for some of simpiler tasks.










.

Relevant Pages

  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... While attempting to install SP4, it comes up immediately after I ... to be on one of the nodes that can bring SQL Server online and apply SP3a, ...
    (microsoft.public.sqlserver.clustering)
  • Re: SP4 on SQL 7.0
    ... the SQL SP. ... I suspect that if we install sp4 again, ... >>>SQL Server Development Team ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server in SBS 2003
    ... mentioned before, 2005 is still being beta tested, for SBS. ... If so, install SQL Server 2000. ... SP4 brings them all up to speed at once if you use the ...
    (microsoft.public.windows.server.sbs)
  • Re: Using Query Analyzer with SQL 2005
    ... I suppose the "production" SP4 will just have to wait until I wipe ... What version of SQL Server 2000 Query Analyzer are you using? ... that comes with SQL Server 2005 that I can contiue to install on my ...
    (microsoft.public.sqlserver.tools)
  • Re: DTS & MAPI problem (semmap.dll)
    ... SQL Server 2000 SP4 ... Only difference was the install order. ... Are you using the MSDE or letting Backup Exec ...
    (microsoft.public.sqlserver.dts)