SQL80001: Incorrect syntax near ':'
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.