errors on install

hey folks

i am getting the following error while trying to install the system:


An error occured: Line 9: Incorrect syntax near '('.
Running scripts from file: D:\hshome\user\domain.com\install\Scripts\nopCommerce_createDatabase.sql

i get this error no matter if i am installing via the web, or running the sql script directly from MS SQL Manager Studio.

any ideas what it could be?

thanks!

Hi,

Can you post the first 13 lines of file please, to look at the code.

What database version are you using? SQL Server 2000?

Thanks guys.

yes, its mssql 2000.

here are the first 13 lines:

CREATE TABLE [dbo].[Nop_CustomerSession](
  [CustomerSessionGUID] [uniqueidentifier] NOT NULL,
  [CustomerID] [int] NOT NULL,
  [LastAccessed] [datetime] NOT NULL,
  [IsExpired] [bit] NOT NULL,
 CONSTRAINT [PK_Nop_CustomerSession] PRIMARY KEY CLUSTERED 
(
  [CustomerSessionGUID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Nop_CustomerSession_CustomerID] ON [dbo].[Nop_CustomerSession] 
(
  [CustomerID] ASC

snooper wrote:

You need "MS SQL Server 2005 or above" (https://www.nopcommerce.com/technologysystemrequirements.aspx)

.