You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Now look at the debug information in the debug table that has its first cell contain "procedure_parameters". It shows an interesting value in the "query_text_search" column. On a server with Query Store enabled on five non-system databases, the value in that cell is
and on a server with twenty-three such databases, it shows the same, but with twenty-three \s on each side.
I take this as a sign that @get_all_databases = 1 and @escape_brackets = 1 don't work well together.
Furthermore, @escape_brackets does not appear in the readme on GitHub.
What is the expected behavior?
I presume that the number of \ shown in the cell in question should not be proportional to the number of non-system databases that have Query Store active.
Also, @escape_brackets should appear in the readme on GitHub.
Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
I do not expect this to be version dependent.
The text was updated successfully, but these errors were encountered:
…nd hitting multiple databases
This is the smallest change that I could think of that would closeerikdarlingdata#380. I have made an effort to be faithful to the original's style, but I must admit that I have not taken the time to become greatly familiar with this procedure. What I have done appears to work, but I have no idea if this is the best way.
Version of the script
4.2.
What is the current behavior?
On a system with Query Store enabled on multiple non-system databases, run
Now look at the debug information in the debug table that has its first cell contain "procedure_parameters". It shows an interesting value in the "query_text_search" column. On a server with Query Store enabled on five non-system databases, the value in that cell is
%\\\\\[AnyStringStartingAndEndingWithSquareBrackets]\\\\\]%'
and on a server with twenty-three such databases, it shows the same, but with twenty-three
\
s on each side.I take this as a sign that
@get_all_databases = 1
and@escape_brackets = 1
don't work well together.Furthermore,
@escape_brackets
does not appear in the readme on GitHub.What is the expected behavior?
I presume that the number of
\
shown in the cell in question should not be proportional to the number of non-system databases that have Query Store active.Also,
@escape_brackets
should appear in the readme on GitHub.Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
I do not expect this to be version dependent.
The text was updated successfully, but these errors were encountered: