SQL error using script to create

Question

I used SQL Server Management Studio in a table with Create Script in New and made small changes. Give me the error "Incorrect syntax near" ("for parameter" (after "WITH"

/* EventType Table Creation */ CREATE TABLE [EventType] ( [pkEventID] [int] IDENTITY(1,1) NOT NULL, [Description] [nvarchar](50) NOT NULL, [BeginDate] [datetime] NOT NULL, [EndDate] [datetime] NOT NULL, [Comments] [nvarchar](500) NOT NULL, CONSTRAINT [PK_EventType] PRIMARY KEY CLUSTERED ( [pkEventID] ASC ) WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] ) ON [PRIMARY] GO 

Answer 1

In which version of Microsoft SQL Server do you execute this CREATE TABLE statement? According to the documentation, MS SQL Server 2000 does not recognize the syntax for WITH (...index options...) . This syntax is supported in MS SQL Server 2005 and later.

Even if you are using SQL Managment Studio 2005, you can connect to MS SQL Server 2000. To check the version, try this query:

 SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition'); 

MS SQL Server 2000 productversion - 8.x.

MS SQL Server 2005 productversion - 9.x.

MS SQL Server 2008 productversion - 10.x.