Home > Archive > MS SQL Server > October 2006 > 2000 QA against 2005 Server









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author 2000 QA against 2005 Server
Hassan

2006-10-24, 6:33 pm

Can you use the 2000 Query analyser to connect to SQL 2K5 ?


Hari Prasad

2006-10-24, 6:33 pm

Hi,

You could connect a SQL Server 2005 server using Query analyzer, but Query
Analyzer will not fully support
new SQL Server 2005 features.

Thanks
Hari
SQL Server MVP

"Hassan" <Hassan@hotmail.com> wrote in message
news:OldVALD5GHA.4996@TK2MSFTNGP04.phx.gbl...
> Can you use the 2000 Query analyser to connect to SQL 2K5 ?
>



Tibor Karaszi

2006-10-24, 6:33 pm

Also, some of the stuff in QA doesn't work well against 2005. Perhaps "script" (I don't recall by
heart). But Object Browser can at least browse stuff, and you can execute queries. If you are
willing to accept some funky behavior here and there, you should be fine.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/



"Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
news:uILkIvD5GHA.1244@TK2MSFTNGP03.phx.gbl...
> Hi,
>
> You could connect a SQL Server 2005 server using Query analyzer, but Query Analyzer will not fully
> support
> new SQL Server 2005 features.
>
> Thanks
> Hari
> SQL Server MVP
>
> "Hassan" <Hassan@hotmail.com> wrote in message news:OldVALD5GHA.4996@TK2MSFTNGP04.phx.gbl...
>
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com