2

I'm trying to install Brent Ozar's SP_BlitzFirst on a user database on an Azure SQL Database instance.

However, I get the error:

The module 'sp_BlitzFirst' depends on the missing object 'sp_MSforeachdb'. The module will still be created; however, it cannot run successfully until the object exists."

I have a nasty feeling that I'm missing something obvious, but I don't really know where to go from here... Can anyone advise please?

I downloaded it today from https://www.brentozar.com/first-aid/ so I'm assuming it's the latest version.

1 Answer 1

3

As the readme states:

Azure SQL DB - not supported. Some of the procedures work, but some don't, and Microsoft has a tendency to change DMVs in Azure without warning, so we don't put any effort into supporting it. If it works, great! If not, any changes to make it work would be on you. See the contributing.md file for how to do that.

2
  • Ah. Yes, thanks. I missed that amid my excitement that most versions of SQL Server since Noah built an ark are supported... Commented Jan 10, 2023 at 6:54
  • @Brent Ozar That is an uncomfortable place to be in: finding out my trusty tools have been confiscated for the sake of progress. Sigh.
    – callisto
    Commented Jan 26, 2023 at 11:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.