SSMS copy and paste from results grid losing CR+LF - SQL Server 2016

by Darren Green 6 Jun 2016 22:37
When you start using SQL Server Management Studio (SSMS) for SQL Server 2016, you may notice a new bug feature to do with the Results Grid. If you copy and paste one or more cells from the results grid the copied text loses any carriage returns (CR) and line feeds (LF). To avoid too much head scratching, just remember there is a new setting available. You can access this via Options dialog from the Tools menu (Tools –> Options). Navigate to the Query Results –> SQL Server –> Results to Grid section as shown below. The offending item is the Retain CR/LF on copy or save, which you proba... [More]