FIX: When you access a table source in a referenced project by using an alias in VSTS 2008 Database Edition GDR, if you refer to the table source by using a three-part or four-part name, you receive TSD03006 errors or TSD04151 warnings

Consider the following scenario in Microsoft Visual Studio Team System 2008 Database Edition GDR:

• You define a table source object (such as a table or a view) in a database project that is referenced by another database project.
• In the referencing project, you add a view or a stored procedure that accesses the table source in the referenced project by using an alias. The table source is referred by using a three-part name or four-part name. For example, the name is [$(Server name)].[$(Database name)].[dbo].[View_name].
• Then, you save the projects or build the projects.

In this scenario, if you use a view, you receive an error message incorrectly that resembles the following::

• TSD03006: View: [dbo].[view_name] 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: object_name1, object_name2, object_name3,…
• TSD03006: View: [dbo].view_name].[name] has an unresolved reference to object object_name

If you use a stored procedure, you receive a warning message incorrectly that resembles the following:

• TSD04151: Procedure: [dbo].[procedure_name] 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: object_name1, object_name2, object_name3,…
• TSD04151: Procedure: [dbo].[procedure_name].[name] has an unresolved reference to object object_name

To resolve this problem, upgrade to Microsoft Visual Studio Team System 2008 Database Edition GDR R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
Note Microsoft Visual Studio Team System 2008 Database Edition GDR R2 replaces Microsoft Visual Studio Team System 2008 Database Edition GDR.