Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > sql server > answers

Is SQL Server 2005 backward compatible with SQL Server 2000

Newbie
  
Join Date: May 2007
Posts: 2
#1: May 28 '07
Please confirm whether all queries on SQL Server 2005 is compatible with SQL Server 2000.

almaz's Avatar
Expert
  
Join Date: Dec 2006
Location: Kyiv, Ukraine
Posts: 167
#2: May 29 '07

re: Is SQL Server 2005 backward 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"
Reply

« previous question | next question »

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,419 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved