Tech Off Post

Single Post Permalink

View Thread: Trying to use SQL studio 2005 to script tables for SQL 2000
  • User profile image

    WITH (IGNORE_DUP_KEY = OFF)  is the problem.

    Looking at the CREATE TABLE syntax for SQL2000 I do not think it's legal, although it is in SQL2005.

    You will need to modify the system generated scripts by hand to tweak the differences or just use SQL2000 to auto-generate the scripts.