SSMS 2012 does't open sparse column to edit data by Fabio Lunardon

Closed

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

Type:	Bug
ID:	776900
Opened:	1/18/2013 7:41:04 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

If a table has mixed not sparse column and sparse column,
edit data doesn't put sparse column into the sql command.

Change the fields list sql command with a "*" fix the bad.

Details (expand)

Italian

SQL Server 2012 - Business Intelligence Edition

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

Windows 7 Ultimate

Italian

Define a table with 1 sparse column
Open the table to edit rows.
Ok!
Close the tab.
Add 1 not sparse column.
Open the table to edit rows.
Bad! The sparse column is not loaded.

Bad! The sparse column is not loaded.

All column are loaded.

X64

0 attachments

Posted by Microsoft on 2/6/2013 at 12:01 PM

Hi!, thanks for writing in to Microsoft and reporting this bug.

We took a look at this bug and triaged it against several others and unfortunately, it did not meet the bar to be fixed. While we are closing this bug as 'won't fix', we have taken note of this internally and we will try & incorporate this request when we revisit this functionality in a future release of SSMS.

Regards,
Sanjay Nagamangalam, SQL Server Manageability

Microsoft