Carlo Romagnano (4/18/2014)
In SSMS 2008 r2, results could be copied only in grid mode or if the amount of the text is less than 2MB. If text is more than 2MB you should save results in a file.rpt
This QotD has become quite the "fun facts" collection about SSMS query results 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP