SSMS Results to Grid – CRLF not preserved in copy/paste – any better techniques?

by

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).

  1. Tools > Options
  2. Expand Query Results > SQL Server > Results to Grid
  3. Tick Retain CR/LF on copy or save
  4. Restart SSMS

This will cause CR, LF, and CRLF to be treated as newlines when you copy a cell.

More Related Contents:

  1. Format SQL in SQL Server Management Studio
  2. What is the use of GO in SQL Server Management Studio & Transact SQL?
  3. What is the best way to auto-generate INSERT statements for a SQL Server table?
  4. How to see query history in SQL Server Management Studio
  5. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  6. sql server invalid object name – but tables are listed in SSMS tables list
  7. How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
  8. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  9. Add alternating row color to SQL Server Reporting services report
  10. Query times out when executed from web, but super-fast when executed from SSMS
  11. How do you specify a different port number in SQL Management Studio?
  12. Unique constraint on multiple columns
  13. Import / Export database with SQL Server Server Management Studio
  14. Removing the remembered login and password list in SQL Server Management Studio
  15. SQL Server (localdb)\v11.0 explained
  16. The request failed or the service did not respond in a timely fashion?
  17. FOR JSON PATH results in SSMS truncated to 2033 characters
  18. SQL Server 2008 can’t login with newly created user
  19. Date conversion and culture: Difference between DATE and DATETIME
  20. Why does select SCOPE_IDENTITY() return a decimal instead of an integer?
  21. How to remove accents and all chars a..z in sql-server?
  22. Escape Character in SQL Server
  23. Retrieve data from stored procedure which has multiple result sets
  24. Use of Begin / End Blocks and the Go keyword in SQL Server?
  25. Ampersand (&) operator in a SQL Server WHERE Clause
  26. how to write number to word function in sql server [closed]
  27. Milliseconds wrong when converting from XML to SQL Server datetime
  28. Using GROUP BY with FIRST_VALUE and LAST_VALUE
  29. How does SQL Server decide format for implicit datetime conversion?
  30. The Best Way to shred XML data into SQL Server database columns

Leave a Comment