I run Blitz weekly and on SQL 2008 express server the Blitz result found that i have SP_blitz over 6 month old. When i try to update everything to the latest , this is what i get . Procedure sp_Blitz, Line 3123 Invalid column name 'is_current_owner'. Procedure sp_BlitzLock, Line 317 Incorrect syntax near 'THROW'. Currently I have Sp_Blitz May 20 2021 version
Asked
Active
Viewed 247 times
2 Answers
1
sp_BlitzLock only supports SQL Server 2012 & newer.
For what it's worth, Microsoft also only supports SQL Server 2012 & newer as well.
Brent Ozar
- 13,174
- 14
- 68
- 91
-
Thank you , the server have to be upgraded soon – MJ8 May 02 '22 at 17:35
0
I ran into this today, and I found that the latest First Responder Kit version where you can run "Install-All-Scripts.sql" on a SQL Server 2008 R2 instance without it throwing any errors is from 2020-12-11.
Obviously the recommended course of action is to upgrade to a supported SQL Server version.
Aaron Gonzalez
- 1
- 1