FIX: Error message when you use an OPENXML function in a SELECT statement in a Microsoft SQL Server 2000 database project in Microsoft Visual Studio Team System 2008 Database Edition GDR: "The model already has an element that has the same name"

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

SYMPTOMS

You have a Microsoft SQL Server 2000 database project in Microsoft Visual Studio Team System 2008 Database Edition GDR. When you add a stored procedure or a view that uses an OPENXML function in a SELECT statement to retrieve objects from an XML document, you receive the following error message and warning message in the Error List window:

Error message:
TSD04105: The model already has an element that has the same name.
Warning message:
TSD03119: The reference to the column <column_name> could not be resolved.
In this situation, you cannot build the project successfully.

CAUSE

This problem occurs because the Microsoft Visual Studio Team System 2008 Database interpreter does not interpret the OPENXML function in the SQL Server 2000 database project.

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.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about the OPENXML function, visit the following Microsoft Web site:
http://msdn.microsoft.com/en-us/library/ms186918(SQL.90).aspx

Properties

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

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