Search code examples
sp-blitz

Error updating Sp_Blitz to the latest version


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


Solution

  • sp_BlitzLock only supports SQL Server 2012 & newer.

    For what it's worth, Microsoft also only supports SQL Server 2012 & newer as well.