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
What is the current behavior?
minor mistakes in the code - see the insert statements around the max number of databases
INSERT #BlitzIndexResults ( Priority, check_id, findings_group, finding, URL, details, index_definition,
index_usage_summary, index_size_summary )
VALUES (
-1, -- ends up in the Priority column
0 , -- ends up in the check_id column
@ScriptVersionName, -- ends up in the findings_group column
CASE WHEN @GetAllDatabases = 1 THEN N'All Databases' ELSE N'Database ' + QUOTENAME(@DatabaseName) + N' as of ' + CONVERT(NVARCHAR(16), GETDATE(), 121) END, -- ends up in the finding column
N'From Your Community Volunteers', -- ends up in the URL column - surely this is wrong?
N'http://FirstResponderKit.org', -- ends up in the details column - surely this is wrong?
N'', -- ends up in the index_definition column
N'', -- ends up in the index_usage_summary column
N'' -- ends up in the index_size_summary column
)
If the current behavior is a bug, please provide the steps to reproduce.
run with a large number of databases - the URL ends up in the wrong column
What is the expected behavior?
that the correct columns are inserted into
Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
not specific to a version of SQL server (but I happen to be on Windows and Linux with v2022)
The text was updated successfully, but these errors were encountered:
garyhuntddn
changed the title
Minor fixes
Inserted columns are incorrect (probably just swapped) in a couple of places
May 6, 2024
Version of the script
dev branch
What is the current behavior?
minor mistakes in the code - see the insert statements around the max number of databases
Same with the other query fixed in #3512
If the current behavior is a bug, please provide the steps to reproduce.
run with a large number of databases - the URL ends up in the wrong column
What is the expected behavior?
that the correct columns are inserted into
Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
not specific to a version of SQL server (but I happen to be on Windows and Linux with v2022)
The text was updated successfully, but these errors were encountered: