Formatting inconsistency for MS_Description field

EmasterEmaster Posts: 1 New member
When I use SQL Doc to add details to the "MS_Description" field, I use line breaks to properly format text across multiple lines.
The appearance in SQL Doc is like this:


However, when I save the changes to the database, and I view the MS_Description property on the field via SSMS, it ignores my line breaks, and the the text is all on one line, like this:


If I then add the line breaks within SSMS, save the changes, and then go back and refresh my SQL Doc project, then it appears like this within SQL Doc (double line spacing!)

Is there any way to keep the line breaks consistent between SQL Doc and the database properties?

Tagged:

Answers

  • Alex BAlex B Posts: 1,153 Diamond 4
    Hi @Emaster,

    I see this happening too, but unfortunately I'm not sure there's anything we can do as it looks like it's an SSMS display issue. 

    If you copy out the single line of text from SSMS and paste it into a text editor it still has the line breaks (at least it did for me), so it looks like SSMS is not displaying the CR/LF.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.