468,278 Members | 1,578 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,278 developers. It's quick & easy.

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.
May 28 '07 #1
1 1570
almaz
168 Expert 100+
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"
May 29 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Howard | last post: by
11 posts views Thread by Sean Campbell | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.