How can we help you today? How can we help you today?

WAIT_STATS_CAPTURE_MODE

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

torsten.strauss
0

Comments

2 comments

Sort by
  • Alex B
    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
    Alex B
    0
  • Alex B
    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
    Alex B
    0

Add comment

Please sign in to leave a comment.