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

This article has been archived. It is offered "as is" and will no longer be updated.
SYMPTOMS
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
RESOLUTION
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:
970479 List of fixed issues in the Microsoft Visual Studio Team System 2008 Database Edition GDR R2

Note Microsoft Visual Studio Team System 2008 Database Edition GDR R2 replaces Microsoft Visual Studio Team System 2008 Database Edition GDR.
Properties

Article ID: 970567 - Last Review: 12/10/2015 19:29:51 - Revision: 3.0

  • Microsoft Visual Studio Team System 2008 Database Edition
  • kbnosurvey kbarchive kbexpertiseadvanced kbqfe kbsurveynew kbprb KB970567
Feedback