Copy-Paste does not working properly in SQL Server Management Studio - by Tryout User

Status : 


Sign in
to vote
ID 511701 Comments
Status Active Workarounds
Type Bug Repros 1
Opened 11/18/2009 1:07:33 AM
Access Restriction Public


You cannot copy more than 100000 rows from SQL Server Management Studio query edit window or "Messages" tab that appears after executing T-SQL batch.

It is not a Windows clipboard limitation, because you could easily copy and paste any number of rows from notepad to Word, for example.

There is no limitations on how many rows you could paste into SQL Server Management Studio.
Sign in to post a comment.
Posted by Microsoft on 11/1/2010 at 10:25 AM
Hello Andrey,
Thank you for reporting the problem via connect. Sorry for the delay in responding to this.

Currently we are tracking the same issue through different work item, see this connect request ( For now I am resolving this as duplicate of feedback ID 479617.

If you have any other comments or feeback then feel free to contact me directly at

Nikhil Kumar
Posted by Possum22 on 12/9/2009 at 9:20 PM
Just started using 2008 SMS and found the same problem. I looked for a configuration parameter but could not find one. Is this a bug or one of Microsoft's usual arcane and stupid "improvements"?