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.
Author |
Topic |
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-02-05 : 11:06:52
|
I am getting the following error on a sql server 2008 r2 database:Msg 102, Level 15, State 1, Line 2Incorrect syntax near '('.Msg 319, Level 15, State 1, Line 17Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.Can you tell me what is wrong with the following sql:SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOALTER TABLE [dbo].[eRPT_Transaction_Tracking]( [eRpt_Tracking_ID] [numeric](18, 0) IDENTITY(1,1) NOT NULL, [Package_ID] [varchar](50) NOT NULL, [Received_Date] [datetime] NULL, [Download_Date] [datetime] NULL, CONSTRAINT [PK_eRpt_Package] PRIMARY KEY CLUSTERED ( [eRpt_Tracking_ID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
|