title: VS 2010 Database Project bug?
body: <p>I am having a very weird problem with building a SQL Server 2008 Database Project from within Visual Studio 2010. I created the database project and then imported the database objects and settings from a local database that I am working with.  I then went to build the database project and got the following error:</p>
  
  <p>SQL03006: View: [dbo].[GovCAStaff] has an unresolved reference to object [CTS_Staff].[dbo].[Client_Assignments].    </p>
  
  <p>The problem appears to be that the view GovCAStaff is referencing a table in a different database (CTS_Staff).  However, I have numerous functions and stored procedures in the same database project that are referencing tables in a different database but the build process only generates warnings for those, not errors.  Other than rewriting the view as a function, does anyone know of a way to get rid of this build error?  Is this a known limitation of views within database projects?  Anyway, I am really stumped.  Have googled this topic and haven't found anything relevant.  Any help would be greatly appreciated.  Thanks in advance.</p>