FG
💻 Software

preserving \n from SQL Server Management Studio

Fresh5 days ago
Mar 15, 20263310 views
Confidence Score0%
0%

Problem

I have a column called and can be pretty big because essentially it stores the event log of an entire batch process. The problem is that when I go into the query window and do a select like this When I cut and paste the text of the event log into Notepad, it removes all of the NewLines and is just …

Error Output

SELECT EventLog from BatchProcess

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: preserving \n from SQL Server Management Studio

Low Risk

To deal with the truncation try converting it to XML for processing Code modifed from Martin's Smith's answer to https://stackoverflow.com/questions/2759721/how-do-i-view-the-full-content-of-a-text-or-varcharmax-column-in-sql-server-200 This may als…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment