I need to do some quick analysis on a error log table, so was running a grouping query on the log table.
To get the results into excel I wanted to cut and paste the results from SSMS query window into excel.
Annoyingly the .Net Exceptions where going into Excel on new rows which made it unreadable.
With SQL 2012 the line feeds and carriage returns are preseved and needed to be filtered out in the query
SELECT COUNT(*) as count, replace(replace(Message, char(10), ''''), char(13), '''') as ''Message'' FROM Log
For a few weeks I had a really annoying issue with Sql Server Management Studio freezing on start up, this happened a few times at crucial moments and caused me delays.
I tried several re-installs and repairs and even the 2016 RC version, but it would just keep happening randomly.
Until I found his blog and following the second option to clear the profile information.
An bingo it never happened again, turns out the profile data is not removed on a uninstall.