Trying to deploy sp_blitzIndex - but fails I'm trying to deploy the sp_blitzIndex procedure from Brent Ozar. I'm running it in a query window, in SSMS and get the following error:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'tempdb..SQLServerCheckup_2A98B846_4179_496B_AAF8_60B405E3ED68_waits'.
Starting run. sp_BlitzIndex(TM) v7.99999 - December 11, 2020
This is being done on the master DB. I'm running SQL Server 2019 developer edition on my local machine.
Any suggestions on a fix?
You're trying to deploy something other than sp_BlitzIndex. The warning that you're getting is part of a paid product that we offer, and I'm guessing that you copy/pasted that script from another source.
Try downloading a fresh copy of sp_BlitzIndex from one of the official sources, like http://firstresponderkit.org or https://www.brentozar.com.