FIX: Error message when you add a new column that has the same name as a refactored column in Visual Studio Team System 2008 Database Edition GDR: “The new name is already in use as a COLUMN name and would cause a duplicate that is not permitted”

Article translations Article translations
Article ID: 970559 - 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 have a table in a Microsoft SQL Server database project..
  • In the Schema View, you rename a column of a table.

    Note In the Microsoft Visual Studio Schema View, you right-click a column, point to Refactor, and then click Rename. Then, you rename the column in the Rename dialog box.
  • You add a new column in this table whose name is the same as the old name of the refactored column.
  • You deploy the project to a database.
In this scenario, you cannot deploy the database project and you receive the following error message:
<Project_name>.dbschema(0,0)Error TSD01268: .Net SqlClient Data Provider: Msg 15335, Level 11, State 1, Procedure sp_rename, Line 402 Error: The new name ‘new column name’ is already in use as a COLUMN name and would cause a duplicate that is not permitted.

An error occurred while the batch was being executed.

CAUSE

This problem occurs because the Preservation of Intent feature in which the schema model also tries to change the new column name to the refactored 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.

STATUS

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

MORE INFORMATION

The Preservation of Intent feature enables the deployment of refactoring changes as the user intends.

Properties

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

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