Microsoft SQL Server 2005/2000 Compatibility Problem: SQL 2005 CREATE TABLE Syntax Fails in SQL 2000

One glaring difference in the CREATE TABLE syntax between SQL 2000 and 2005 is this 2005 clause:

WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

The only WITH clause support in SQL Server 2000 is WITH FILLFACTOR.

mod date: 2008-05-12T20:19:56.000Z