SSMS – Can not paste more than 43679 characters from a column in Grid Mode

Ever tried copying large data from Ms SQL Server? Good luck – It only copies 43679 characters. There is no way to increase this limit. A feature request has been filed: https://connect.microsoft.com/SQLServer/feedback/details/499608/ssms-can-not-paste-more-than-43679-characters-from-a-column-in-grid-mode. I don’t think this will be fixed anytime soon since the interface is meant to be admin interface and not a developer tool. I found a couple of workarounds with this (esp. for XML data) but my XML is really huge and it takes a lot of processing power to make that work. In short, it does not work for me.

Presentation1

image

Best option is to right click the cell as shown above and use “Save result as” to export data into say : .cvs file which opens up to reveal the entire cell data. Now copy paste your data into your favorite editor like Notepad++ and use XML Tools to indent it into XML (if it is XML)

image

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s