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
For large results (like 300,000+ rows) I prefer file.txt for later usage, so you can open an Excel sheet & import it from Text.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant