DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP issue
ls2081
Posts: 2
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
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