VSTS 2008 Database Edition doesn't seem to know 'DATEADD' constants, any ideas?

Posted by Marcel Marchon on Stack Overflow See other posts from Stack Overflow or by Marcel Marchon
Published on 2009-12-30T16:50:15Z Indexed on 2010/03/28 3:03 UTC
Read the original article Hit count: 324

Filed under:

vsts2008

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 permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

Anybody have an idea what is wrong here?

Related posts about vsts2008

TFS Build errors TF224003, TF215085, TF215076

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am using TFS2008 and VS2008. I run nightly builds for about 20 applications using one build agent and the builds are scheduled for either 1am or 2am. Most of the build succeed, however 6 of them fail regularly with similar errors. The errors are either the first two below, or the third one… >>> More
Cannot start TFS Build service: Error 1227

as seen on Stack Overflow - Search for 'Stack Overflow'
When I try to start the TFS 2008 Build service on the port 9191 I get the following error message: Windows could not start the Visual Studio Team Foundation Build service on Local Computer. Error 1227: The network transport endpoint already has an address associated with it. If… >>> More
video file download issue

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone, I am using VSTS 2008 + C# + .Net 3.5 + Silverlight 3.0 + ASP.Net to develop a Silverlight application (a video media player) in browser and the function is simple, just use MediaElement to play a remote video file. The remote server is Windows Server 2008 + IIS 7.0 + IIS Media Bit… >>> More
Unable to cast object of type 'System.Object[]' to type 'System.String[]'

as seen on Stack Overflow - Search for 'Stack Overflow'
I am developing a C# VS 2008 / SQL Server website application. I am a newbie to ASP.NET. I am getting the above error, however, on the last line of the following code. Can you give me advice on how to fix this? This compiles correctly, but I encounter this error after running it. DataTable dt;… >>> More
Silverlight XAML layout issue

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone, I am using Silverlight 3.0 + .Net 3.5 + VSTS 2008 + C# to develop a simple video application using the open source slvideoplayer of Silverlight. http://slvideoplayer.codeplex.com/ For the player, the play control is at the bottom of the rendering video, any ideas how to place play… >>> More

Developer IT

VSTS 2008 Database Edition doesn't seem to know 'DATEADD' constants, any ideas? - Developer IT

VSTS 2008 Database Edition doesn't seem to know 'DATEADD' constants, any ideas?

vsts2008

Related posts about vsts2008

TFS Build errors TF224003, TF215085, TF215076

Cannot start TFS Build service: Error 1227

video file download issue

Unable to cast object of type 'System.Object[]' to type 'System.String[]'

Silverlight XAML layout issue

Categories cloud