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

Article translations Article translations
Article ID: 970567 - View products that this article applies to.
Expand all | Collapse all

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: July 20, 2009 - Revision: 3.0
APPLIES TO
  • Microsoft Visual Studio Team System 2008 Database Edition
Keywords: 
kbexpertiseadvanced kbqfe kbsurveynew kbprb KB970567

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com