CODEWITHSUNDEEP
sql-serversql-server-2005sql-server-2000backwards-compatibility
Matt Pfefferle
Matt Pfefferle

Reputation: 209

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?

Upvotes: 2

Views: 1623

Answers (2)

Eclipse
Eclipse

Reputation: 45493

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

Upvotes: 1

Kenneth Cochran
Kenneth Cochran

Reputation: 12064

I know of no summary of Transact SQL changes from 2000 to 2005. There are a few books that take a detailed look at the changes but I wouldn't call them a summary.

For a more immediate answer to your client's problem you could try comparing the specifications for the 2000 and 2005 versions of the CREATE TABLE function.

Upvotes: 0

Related Questions