Options

WAIT_STATS_CAPTURE_MODE

torsten.strausstorsten.strauss Posts: 266 Silver 3
in SQL Prompt
Hi Redgate Team,

SQL Prompt will not format the following code and reports an error.
Thanks for fixing!

USE [master]
GO
ALTER DATABASE [AdventureWorks2017] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 8), WAIT_STATS_CAPTURE_MODE = OFF)
GO

Tagged:
· Share on Twitter

Answers

  • Options
    Alex BAlex B Posts: 1,132 Diamond 4
    Hi Torsten,

    Thank you for that I've passed this on to the team for their consideration.  I will let you know when I have an update!

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
  • Options
    Alex BAlex B Posts: 1,132 Diamond 4
    Hi @torsten.strauss,

    The team have fixed this as much as they are able to, due to there being an issue in the Microsoft Parser.

    There was an (unrelated) issue in 10.1.6 that some people hit, so it will be available widely in 10.1.7.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.