SQL Server 2005 / 2000 compatibility

Hot Topic

vs 2005 SQLserverexpress without mgmt studio
How to retrieve data from query and link the data to a data number?
BSM with SSRS(2005) on a different box
But the SQL Server 2005 optimiser is inconsistent
mysql limit equivalent
Problem to connect Access 2003 to SQL Server 2005 Express
Custom Assembly generates error in Aggregation Wizard
Support for Execute DTS 2000 Package Task on Win 64 AMD?
Fatal Error doing simple queries from an sql 2000 to sql 2005 exported database
response time when browse

SQL Server

Sql Server Begin Transaccion-Commit Transaccion problem
Error creating view from DB2 Linked Server if table has large number of rows.
Double quotes in ASCII file
Giving roles access to perspectives
MSSQL 2005 JuneCTP Install Issue
dynamic SQL
Tell to split on change of ID
SSEUtil.exe SQL Server Express Utility
Data Source passwords in Config Files
OLAP Analysis Services: Errors in Encryption Library

SQL Server 2005 / 2000 compatibility

Can I upgrade my SQL Server instance to 2005, but keep one of the databases in a 2000-compatible format We want to upgrade, but we have vendor software that is not 2005-supported. (Might work, but we'd be on our own.)



Answer this question

SQL Server 2005 / 2000 compatibility

  • TheGeoff

    Would need more information, but you would need to run two servers and the apps would have to reference which one they needed.  I am working on mirgating two of my apps to SQL Server 2005 and still support 2000 versions.  It is going fine and .Net 2003 does not know the difference.
  • SQL Server 2005 / 2000 compatibility
Answer this question