Copy/Paste of row with multi-line text in Management Studio 2008 results in corrupted data by It Dept - Devlopment

Closed

as Fixed

Type:	Bug
ID:	415157
Opened:	2/16/2009 4:06:39 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

When copying a row in Management Studio that contains multi-line content only partial data is inserted into the new row resulting in a corrupted row.

This bug makes it nearly impossible to use the "Edit top n rows" facility in Management Studio since you have to be dead sure no columns contain multi-line text before copy/paste.

Details (expand)

English

SQL Server 2008 - Standard Edition

Tools (SSMS, Agent, Profiler, etc.)

Windows XP SP2 Professional

English

Open SQL Server Management Studio 2008
Connect to a database (Any version of SQL Server)
Expand Object Explorer and find a table with a text column
Right click table and select "Edit top n rows"
Select a row that contains multi-line text in one of the columns
Right click row and select "Copy"
Move to the bottom of the grid
Right click the "New row" row and select "Paste"

Columns that contain multi-line text only the very first line is inserted into the new row therefore invalidating the newly pasted row

All content of all columns to be inserted into the new row

0 attachments

Posted by Microsoft on 6/27/2011 at 12:28 AM

Greetings from the SQL Server Manageability team.

Thanks for writing in to Microsoft. We greatly value your feedback. We understand your problem, and how fixing this could improve productivity.

We were able to reproduce this issue, and we have fixed this issue. This will reflect in an upcoming release of SQL Server.

Thanks again for providing feedback and making SQL Server the greatest Database server.

Microsoft