VSTS 2008 Database Edition doesn't seem to know 'DATEADD' constants, any ideas?
- by Marcel Marchon
I'm trying to implement a database build using VSTS 2008 Database Edition. The build always fails on the following constraint:
ALTER TABLE [dbo].[tablename]
ADD CONSTRAINT [DF_tablename_date] DEFAULT (CONVERT([varchar],dateadd(hour,(-1),getdate()),(1))) FOR [date];
The error that it shows is the following:
TSD03082: The name "hour" is not…