Rather than build the SQL database by hand, I'm attempting to run the SQL script. My issue is that I'm receiving several syntax errors of the form below:

Server: Msg 156, Level 15, State 1, Line 9
Incorrect syntax near the keyword 'PRIMARY'.

The line of code in the sql which causes the above error is marked in red below:

---------------------------------------------------------------------
-- Primary Keys
---------------------------------------------------------------------
ALTER TABLE GroupProjects WITH NOCHECK ADD
    CONSTRAINT PK_GroupProjects PRIMARY KEY CLUSTERED
    (
        GroupProjectID
    ) ON PRIMARY
GO

----------

Can anyone offer any advice? I've not used sql scripts much before - and google could not help.

I'm using SQL Server Version 8.00.760.

Thanks,
Greg

Greg,

You can remove the keywords "ON PRIMARY" and your scripts should run just fine.

Thearon

Thanks Thearon,
That worked - could you explain (for my benefit) why I need to remove that syntax on my system - is it a version issue?
Regards
Greg

Greg,

After creating the tables, I let SQL Server generate the script. I have noticed, using SQL Server 2000, that sometimes this causes an error. I believe it may have something to do with how SQL Server is installed (e.g. options selected). However I have not really had the time to dig into the problem deeper.

Thearon

PRIMARY is the name of your filegroup. You can also use DEFAULT. The problem that you're seeing is that both PRIMARY and DEFAULT are already SQL keywords. Replace PRIMARY with [PRIMARY] and all of your scripts will work fine.

I suspect that you used the scripting tool to generate your SQL but then did a search/replace to knock off the [s and ]s, causing your problem.

Nice information here.

Thanks

http://www.website-control.co.uk