How can we help you today? How can we help you today?

DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP issue

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
ls2081
0

Add comment

Please sign in to leave a comment.