SQL Server 2000 vs SQL Server 2005 queries
Posted by scmay on October 10, 2008
This gives an example of SQL queries between SQL Server 2000 and SQL Server 2005
http://www.mssqltips.com/tip.asp?tip=1015
Bumped into this while looking for IGNORE_DUP_KEY
Also realized you can’t put this as part of a table creation unlike SQL Server 2005.

