Sql-server – Invalid column name ‘database_id’

sp-blitzfirstsql serversql-server-2008-r2

I loaded the stored procedure into master and ran:

dbo.sp_BlitzFirst @ExpertMode = 1

I got:

Setting up configuration variables
Msg 207, Level 16, State 1, Line 5
Invalid column name 'database_id'.
Now starting diagnostic analysis
Capturing first pass of wait stats, perfmon counters, file stats
Beginning investigatory queries
Finished running investigatory queries
Waiting to match @Seconds parameter
Capturing second pass of wait stats, perfmon counters, file stats
Analyzing changes between first and second passes of DMVs
Analysis finished, outputting results
Msg 207, Level 16, State 1, Line 5
Invalid column name 'database_id'.

kit version: SQL-Server-First-Responder-Kit-20161210

Microsoft SQL Server Enterprise Edition (64-bit) version 10.50.6000.34

Best Answer

Here are the two stored procedures that need to be updated.

sp_BlitzWho.sql and

sp_BlitzFirst.sql