Posted by obastard on 07/25/06 11:34

Hi
Having a problem with a ms sql 2000 server. The script below was
created i SQL manager 2005 lite and gives a syntax error near '('

ALTER TABLE [dbo].[Community_ActivityLog]
ADD CONSTRAINT [PK_Community_Errors]
PRIMARY KEY CLUSTERED ([activity_ID])
WITH (
PAD_INDEX = OFF,
IGNORE_DUP_KEY = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO

Any ideas of what might be wrong?

/Michael

[Back to original message]