dbTalk Databases Forums  

SQL Server 2005

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss SQL Server 2005 in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
vul
 
Posts: n/a

Default SQL Server 2005 - 11-28-2005 , 03:57 PM






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 With Quote
  #2  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL Server 2005 - 11-29-2005 , 04:25 AM






vul (aaa (AT) optonline (DOT) net) writes:
Quote:
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.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.