SQL error in creating database

When using the installation wizard, I get the following error on step 3:

An error occured: Line 8: Incorrect syntax near '('.
Running scripts from file: C:\nopCommerce_1.10\NopCommerce\NopCommerceWeb\install\Scripts\nopCommerce_createDatabase.sql


Does anyone know what this error means?

Thanks,
Steven

Can you show me first lines of your nopCommerce_createDatabase.sql and nopCommerce_createData.sql located at Install\Scripts folder

Thank you for your response.  The code is as follows

nopCommerce_createDatabase.sql:

/****** Object:  Table [dbo].[Nop_CustomerRole_Discount_Mapping]    Script Date: 02/03/2009 15:49:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Nop_CustomerRole_Discount_Mapping](
  [CustomerRoleID] [int] NOT NULL,
  [DiscountID] [int] NOT NULL,
 CONSTRAINT [PK_Nop_CustomerRole_Discount_Mapping] PRIMARY KEY CLUSTERED 
(
  [CustomerRoleID] ASC,
  [DiscountID] 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
/****** Object:  StoredProcedure [dbo].[Nop_ShippingMethodDelete]    Script Date: 02/03/2009 15:49:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[Nop_ShippingMethodDelete]
(
  @ShippingMethodID int
)
AS
BEGIN
  SET NOCOUNT ON
  DELETE
  FROM [Nop_ShippingMethod]
  WHERE
    ShippingMethodID = @ShippingMethodID
END
GO

nopCommerce_createData.sql:

/****** Object:  Table [dbo].[Nop_LocaleStringResource]    Script Date: 02/03/2009 15:53:23 ******/
DELETE FROM [dbo].[Nop_LocaleStringResource]
GO
/****** Object:  Table [dbo].[Nop_NewsComment]    Script Date: 02/03/2009 15:53:23 ******/
DELETE FROM [dbo].[Nop_NewsComment]
GO
/****** Object:  Table [dbo].[Nop_News]    Script Date: 02/03/2009 15:53:23 ******/
DELETE FROM [dbo].[Nop_News]
GO
/****** Object:  Table [dbo].[Nop_Customer_CustomerRole_Mapping]    Script Date: 02/03/2009 15:53:23 ******/
DELETE FROM [dbo].[Nop_Customer_CustomerRole_Mapping]
GO
/****** Object:  Table [dbo].[Nop_CustomerAttribute]    Script Date: 02/03/2009 15:53:23 ******/
DELETE FROM [dbo].[Nop_CustomerAttribute]
GO
/****** Object:  Table [dbo].[Nop_Address]    Script Date: 02/03/2009 15:53:23 ******/
DELETE FROM [dbo].[Nop_Address]
GO
/****** Object:  Table [dbo].[Nop_ProductVariantAttributeValue]    Script Date: 02/03/2009 15:53:23 ******/
DELETE FROM [dbo].[Nop_ProductVariantAttributeValue]

i have the same error! :-(

The error is in all lines "WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)".
Some suggests???
Thanks  :-)

Are you sure to use MSSQL 2005 or higher ? (theses scripts are not working on SQL 2000)

As per https://www.nopcommerce.com/Documentation/Installation.aspx - SQL Server 2005 and 2008 are supported.

SQL Server 2000 is not supported.

Thanks
Ben

Hi!
yes i use MSSQL 2005, but i have re-installed my SQL and now all ok!
Thank you for interesting. :-)

I am getting that same error she got above running the script from 1.3 database script.  I don't want to reinstall sql though.   What can I do?  It must be a setting in sql setup causing the issue.