SQL Server Home
Copy/Paste of row with multi-line text in Management Studio 2008 results in corrupted data
It Dept - Devlopment
2/16/2009 4:06:39 AM
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.
SQL Server 2008 - Standard Edition
Tools (SSMS, Agent, Profiler, etc.)
Windows XP SP2 Professional
Operating System Language
Steps to Reproduce
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
to post a comment.
Please enter a comment.
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.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft