SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tbl_element_popup_window]( [e_popup_window_id] [int] IDENTITY(1,1) NOT NULL, [e_popup_window_pi_id] [int] NULL, [e_popup_window_instance] [int] NULL, PRIMARY KEY CLUSTERED ([e_popup_window_id] ASC) WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90 ) ON [PRIMARY] ) ON [PRIMARY]
Answer by Kev Riley ·
I'm guessing (as you don't say what the error actually is) that you have scripted this table from a 2005+ server - this syntax for CREATE TABLE is invalid in SQL 2000.
Specifically it is the WITH clause of the PK constraint - the only WITH clause allowed in SQL 2000 was
WITH FILLFACTOR =
See this MSDN link for the correct syntax.