SQL80001: Incorrect syntax near ':'

Posted by Anthony Trudeau on Geeks with Blogs See other posts from Geeks with Blogs or by Anthony Trudeau
Published on Sat, 06 Mar 2010 04:25:05 GMT Indexed on 2010/03/07 23:28 UTC
Read the original article Hit count: 1552

Filed under:

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.

© Geeks with Blogs or respective owner