SSMS Results to Grid - CRLF not preserved in copy/paste - any better techniques?
Solution 1:
This issue has been fixed in SSMS 16.5 build 13.0.16000.28 with the addition of an option to preserve CR/LF on copy/save (more details) (Connect bug).
- Tools > Options
- Expand Query Results > SQL Server > Results to Grid
- Tick Retain CR/LF on copy or save
- Restart SSMS
This will cause CR, LF, and CRLF to be treated as newlines when you copy a cell.