0

Getting the following error when trying to install sp_Blitz on a Azure SQL Database

Msg 40515, Level 15, State 1, Procedure sp_Blitz, Line 16 [Batch Start Line 15] Reference to database and/or server name in 'master.sys.all_objects' is not supported in this version of SQL Server.

I can't see anything in the comments on the SP to suggest that Azure SQL Database isn't supported

closed as off-topic by Erik Darling, mustaccio, Marco, Max Vernon, Colin 't Hart Apr 17 at 19:15

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Erik Darling, mustaccio, Marco, Max Vernon
If this question can be reworded to fit the rules in the help center, please edit the question.

2

In the readme of the first responder kit there is a statement on Azure SQL DB

Azure SQL DB - It's a dice roll. Microsoft changes DMV contents in here without warning, so no guarantees.

There is another explanation by Scott Hodgin and a possible workaround by Henrik Staun Poulsen in this question.

Per Henrik's words

I've tried to make a version of sp_blitz that works on Azure SQL DB. See here Now, I'm looking for people that will test it.

You could test his version of sp_blitz and give him some feedback.

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