Search code examples
sql-serversql-server-2005sql-server-2000backwards-compatibility

SQL language differences between MSSQL 2000 and 2005

My company has an application developed for SQL Server 2005 (among others), and a potential client is attempting to install it on SQL Server 2000. Naturally, installation failed. Specifically, it failed with syntax errors in our CREATE TABLE statements.

Is there a summary of the language differences between these two databases?

Solution

  • You can take a look at the list of breaking changes here at technet.