When you add SQLCMD statements to a pre-deployment or post-deployment file in a database project in Visual Studio 2010. You might see the error “SQL80001: Incorrect syntax near ‘:'”. This is not a real error assuming you have the correct SQLCMD syntax.
To clear the errors temporarily right click on the document and select SQLCMD mode.
Posted on Friday, March 5, 2010 10:25 PM .NET | Back to top