SQL was working fine last week with the old CHAR(13)+CHAR(10) for line feed/carriage return.
DECLARE @text varchar(2000) SET @text = 'Attached is your new reporting ID and temporary password.' + CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10) + 'The new login/password will be updated on ' + Convert(char(10), @ticketdate,101)
Last week this ran as expected giving me nicely formatted text with a space between the lines.
This week, the same code on the same server is returning one long run-on line of text.
This seems like this is a collation issue? Or something like that?
The code has worked as expect so something changed, but I can't identify what might have changed.
This seems like it could be collation issue? But it appears to be the default latin setting.