I had a very strange problem with creating a SQL Server 2008 database project from Visual Studio 2010. I created a database project and then imported the database objects and settings from the local database I'm working with. Then I went to create a database project and received the following error:
SQL03006: View: [dbo]. [GovCAStaff] has an unresolved object reference [CTS_Staff]. [dbo]. [Client_Assignments].
The problem is that the GovCAStaff view is referencing a table in another database (CTS_Staff). However, I have many functions and stored procedures in the same database project that refers to tables in another database, but the build process generates warnings only for those and not for errors. Does anyone know how to rewrite a view as a function, does anyone know how to get rid of this build error? Is this a known limitation on database designs? Anyway, I'm really at a standstill. Share this topic and did not find anything suitable. Any help would be greatly appreciated. Thanks in advance.
source
share