Problem

When I try and run my deploy scripts from DBPro in SSMS I get syntax errors where variables are used.

Solution

Switch on SQL CMD Mode before you execute the SQL file.  To enable the SQL CMD Mode select SQL CMD Mode from the Query menu in SSMS.