title: Unresolved references in Microsoft Visual Studio SQL Database project
body: <p>I have a MS DataBase project in Visual Studio -- after doing a Schema Comparison, I am trying to generate a deploy script, the problem is I get hundreds of Unresolved references errors,such as the following two:</p>
  
  <pre><code>Error   385 TSD03006: View: [auditing].[AuditedEntities] has an unresolved reference to object [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS].  D:\greatProject\Database\greatProject.Database\Schema Objects\Schemas\auditing\Views\AuditedEntities.view.sql   4   14  greatProject.Database
  Error   387 TSD03006: View: [auditing].[AuditedEntities] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS].[C]::[CONSTRAINT_NAME], [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS].[CONSTRAINT_NAME] or [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS].[C]::[CONSTRAINT_NAME].  D:\greatProject\Database\greatProject.Database\Schema Objects\Schemas\auditing\Views\AuditedEntities.view.sql   5   69  greatProject.Database
  </code></pre>
  
  <p>The SPROCS never have issues when they run. Is there a quick and dirty way to fix this? Perhaps even by turning off referential integrity checks perhaps?</p>