Line breaks handled inconsistently by SSMS
There is an option to change this behavior, go to Tools &gt; Options &gt; Query Results &gt; SQL Server &gt; Results to Grid, and check the box for "Retain CR/LF on copy or save":



You may have to exit and re-load SSMS for this change to take effect.