Why output script from VSTS for Database pro failed to execute in Management Studio?
Database pro output scripts are valid t-sql syntax, but remember: Database pro uses SQLCMD to deploy databases.
How can you make it run?
In Management Studio you need to swap into SQLCMD mode.
- Tthrough the Query -> SQLCMD Mode menu.
- Click the red exclaimation icon in your toolbar.