SQL Server 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vul - 28 Nov 2005 21:57 GMT

I have SQL Server 2000 installed on my workstation. I'm using EM to work
with databases on hosting servers (my WEB sites are using SQL Server DBs).
Will I be able to continue to work with SQL Server 2000 databases (create
tables, SPs etc) if I'll install SQL Server 2005 on my machine?
Or If I'll create something from SQL Server Management Panel it's not going
to work?

Thank you
Al

Reply to this Message

Erland Sommarskog - 29 Nov 2005 10:25 GMT

> I have SQL Server 2000 installed on my workstation. I'm using EM to work
> with databases on hosting servers (my WEB sites are using SQL Server DBs).
> Will I be able to continue to work with SQL Server 2000 databases (create
> tables, SPs etc) if I'll install SQL Server 2005 on my machine?
> Or If I'll create something from SQL Server Management Panel it's not
> going to work?

You can install SQL 2005 and EM will continue to work. But you cannot
access SQL 2005 from EM. (Query Analyzer works.)

You can also use Mgmt Studio to access SQL 2000.

Signature

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

Reply to this Message