Parse error

Can anyone tel lme why this does not parse in 2000 but works fine in 2005?

ALTER TABLE Segments ADD CONSTRAINT

PK_Segments PRIMARY KEY CLUSTERED

(

SegmentsUniqueID

) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,

ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

thanks.

The WITH clause for constraints is new to SQL Server 2005. You can set some of the options in SQL2000 using sp_indexoption or create index.|||Thanks