Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 create table with(pad_index=off,)

Author  Topic 

Chap
Starting Member

30 Posts

Posted - 2009-05-26 : 14:41:38
When I try to create a table in SQL Server 2000 using this query

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProspectUpdate](
[RowID] [smallint] NOT NULL,
[LastUpdatedDate] [datetime] NOT NULL,
CONSTRAINT [PK_ProspectUpdate] PRIMARY KEY CLUSTERED
(
[RowID] ASC
)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?


George

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-26 : 14:44:12
remove that with statement and try
Go to Top of Page

Chap
Starting Member

30 Posts

Posted - 2009-05-26 : 15:31:36
Thanks that did work. I was concerned with why the developer had the with statement to begin with. It works fine in SQL SERVER 2005.

George
Go to Top of Page
   

- Advertisement -