I get an unresolved reference to the object [#aspnet_Permissions] 29 July 2011 Donovan-Brown Work (0) Normal 0 false false false EN-US X-NONE X-NONE Problem When I import a database that uses ASP.NET Providers I get an unresolve... [More]
sysobject warnings in my DBPro projects 29 July 2011 Donovan-Brown Work (0) 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 26 July 2011 Donovan-Brown Work (0) 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.
How to override the connection string and target database of a database project 06 September 2010 Donovan-Brown Work (0) Problem: I need to override the connection string and target database of a database project built with Team Build. Solution: Pass the TargetConnectionString and TargetDatabase parameters to team build. Explanation: Although Team Build in 2010 is Windows Workflow based at the end of the day MSBu... [More]
How do I deploy Metadata during my database deploy 06 September 2010 Donovan-Brown Work (0) How to deploy Metadata with my database. [More]
How to deploy a Database Project with Team Build 2010 06 September 2010 Donovan-Brown Work (0) How to deploy your database project using Team Build 2010 [More]