I have a column called
EventLog varchar(max) 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
SELECT EventLog from BatchProcess
When I cut and paste the text of the event log into Notepad, it
- removes all of the NewLines
\nand is just one continous line.
- only copies a certain amount of text into the clipboard and truncates the rest.
How can I get the content of EventLog from the SQL Server Management Studio?