Posted - 05/26/2009 : 14:41:38
| When I try to create a table in SQL Server 2000 using this query
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ProspectUpdate](
[RowID] [smallint] NOT NULL,
[LastUpdatedDate] [datetime] NOT NULL,
CONSTRAINT [PK_ProspectUpdate] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
I receive the following error:
Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
From what I can gather this is a down grade problem. We want to populate SQL Server 2000 database from a SQL Server 2005 database.
Any ideas on how to get around this error?