sysobject warnings in my DBPro projects

Problem My DBPro project references sysobjects and is causing build warnings for example: SQL04151: Procedure: [dbo].[aspnet_AnyDataInTables] has an unresolved reference to object [dbo].[sysobjects].    Solution Add the following DB reference to your database project: C:\Program... [More]

I can't run my scripts created by DBPro in SSMS

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.