Search

SSMS drop column can fail by will_affinity

Closed
as Won't Fix Help for as Won't Fix

1
0
Sign in
 to vote
Type: Bug
ID: 770968
Opened: 11/13/2012 2:30:38 PM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
In the Table Designer, when dropping a column you renamed without committing the SSMS will drop a column with the renamed column versus the original column. SSMS needs to drop the column having the original name, not the last defined by the user, but not committed to the table in Table Designer
Details (expand)

Product Language

English

Version

SQL Server 2012 - Standard Edition

Category

Tools (SSMS, Agent, Profiler, Migration, etc.)

Operating System

Windows Server 2012 Standard

Operating System Language

US English

Steps to Reproduce

1) Right click a table, click Design
2) Change a column name in the designer from, say, ABC to XYZ
3) Right click the column and delete it
4) Click Save

Actual Results

Error: cannot drop column XYZ

Expected Results

Should drop column ABC, since that was how it was originally defined in the table.

Platform

 

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Sethu Srinivasan on 11/14/2012 at 8:54 AM
Please let us know if you see the same issue with SQL Server data tools . You can download SQL Server data tools from http://blogs.msdn.com/b/ssdt/archive/2012/11/07/sql-server-data-tools-november-2012-is-now-available.aspx


Thanks
Sethu Srinivasan [MSFT]
SQL Server
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement