FIX: When you use an XML data type method against the result of another XML data type method in Microsoft Visual Studio Team System 2008 Database Edition GDR, you receive a TSD04151 warning message or a TSD03006 error message incorrectly

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

SYMPTOMS

You use an XML data type method against the result of another XML data type method in a database project in Microsoft Visual Studio Team System 2008 Database Edition GDR. However, you receive the following error message or warning message incorrectly:

If the method is inside a Stored Procedure, a Trigger, a Scalar-valued Function, or a Table-valued Function, you receive the following warning message incorrectly:
TSD04151: Object type: [schema name].[object 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: [dbo].[object name].[column name]::[query].[value] or [object name].[query]::[value].
If the method is inside a View or an Inline Function, you receive the following error message incorrectly:
TSD03006: Object type: [schema name].[object 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: [dbo].[object name].[column name]::[query].[value] or [object name].[query]::[value].

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.

MORE INFORMATION

For more information about the XQuery language, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn.microsoft.com/en-us/library/ms189075.aspx

Properties

Article ID: 970574 - Last Review: July 16, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Visual Studio Team System 2008 Database Edition
Keywords: 
kbqfe kbexpertiseadvanced kbsurveynew kbprb KB970574

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