Alignment

torsten.strausstorsten.strauss Posts: 270 Silver 3
edited November 6, 2017 8:17AM in SQL Prompt
Hi Redgate Team!

After the last update the alignment seems to be wrong.

SELECT_*
FROM___sys.fn_dblog (NULL, NULL)
WHERE
_________[Transaction ID] IN (SELECT [Transaction ID] FROM
sys.fn_dblog ('359:2429:26', '359:2429:26')
);
GO

I do not have any control about the alignment here anymore. Before the update there was no alignment for *, sys.fn_dblog and [Transaction ID].

Answers

  • There were changes to the formatting, especially the defaults. However, you should have control over those alignments, way more than before. Click on the SQLPrompt menu and then "Edit Formatting Styles..." to get started.
  • Hi Grant,

    I really appreciate your support but can you be a bit more precise on that...
    Believe me, I tried to play with the formatting style before my post but I was not able to find a solution.

    Thanks!

    Torsten
  • Hi @torsten.strauss,

    Sorry to hear that the alignment seems to be wrong after updating.

    Would it be possible to paste your expected versus actual examples in a code block on here?
    We will then take those examples and try to reproduce them.

    Best wishes,
    Michael
    Michael Clark
    Technical Lead, SQL Monitor
  • I used "Align subsequent items with first item", "Align items across clauses" and "Align items to tab stops". It seemed to be what you were looking for based on the initial post.
Sign In or Register to comment.