Close this search box.

SQL80001: Incorrect syntax near ‘:’

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

This article is part of the GWB Archives. Original Author: ANTHONY TRUDEAU

Related Posts