install errors SQL

i use the nopCommerce_createDatabase on the install page and also tried on the sql management studio.
i get many errors

anyone? please

Please post the errors messages that you are getting.

P.S: Have you tried installing it using install.aspx page ?

thank you for the quick reply.

i have tried both, the install.aspx and run the nopCommerce_createDatabase.sql on the ms sql server management studio.
in both i get the same error  Incorrect syntax near '('.
it seems that the next line is the problem:
WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]


I also get an error for the sql max
[varbinary](max) NULL,
it does not recognize the max


thanks again

hezy

Download a fresh copy of nopCommerce and then try installing the database.

last copy downloaded yesterday

It seems like you are using an older version  of sql server. Are you using SQL Server 2000 ?

FYI: NopCommerce requires SQL Server 2005 or above

thank u, it was 2000 so i have moved to 2005