sp_Blitz error when creating/updating on SQL Server 2022 and older #3729
Description
Version of the script
8.26 - 20251002
What is the current behavior?
When updating sp_Blitz on a SQL Server 2022 instance or older the following errors occur:
Msg 207, Level 16, State 1, Procedure sp_Blitz, Line 6769 [Batch Start Line 3]
Invalid column name 'group_max_tempdb_data_percent'.
Msg 207, Level 16, State 1, Procedure sp_Blitz, Line 6770 [Batch Start Line 3]
Invalid column name 'group_max_tempdb_data_mb'.
If the current behavior is a bug, please provide the steps to reproduce.
Copy-paste the latest sp_Blitz from the dev branch in a Query Editor tab and press F5.
What is the expected behavior?
To not throw any errors.
Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
Any version that doesn't have those two columns (2022 and older).