DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP issue

ls2081ls2081 Posts: 2
edited September 29, 2014 12:23PM in SQL Compare Previous Versions
Hi,
I have a database connected to Red Gate Source Control. It generates following script for a table's column which works fine:

[LoadDate] DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP

When I use SQL Compare 10.7.0.18 and use same script folder as source and a blank DB as target, I get following line for the same column which gives error:

[LoadDate] [DATETIME] NOT NULL CONSTRAINT [DF__SSISPacka__LoadD__4A37A62] DEFAULT (current_timestamp())

Error:
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '('.

Microsoft SQL Server is not expecting () after CURRENT_TIMESTAMP.

Please let me know what to do.

Thanks
Lateef
Sign In or Register to comment.