I am doing a local query through a remote desktop of a server. It is Management Studio 2005 and the result is large. Somehow, it doesn't let me to copy and paste the result.
- csv format doesn't work since there are some comma in the result then the csv result looks mix up in excel
- When I copy and paste from the grid, Excel doesn't let me to do so no matter in that remote windows or my own windows.
- I tired to get smaller result then copy pieces by pieces, but even 2000 results don't work already, just the size like 200 results would be ok, but there are more than 20000 results.
Any idea how can I solve this problem at work?