Monday, March 12, 2012

Is SQL Server 2005 backward compatible with SQL Server 2000

Please confirm whether all queries on SQL Server 2005 is compatible with SQL Server 2000.SQL Server 2005 introduces a number of new keywords that make full compatibility impossible (because your code may use these keywords as cursor identifiers, etc.). If you want to be sure your queries are 100% compatible, set the compatibility level for your database to "8.0"

No comments:

Post a Comment