1

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

0

1 Answer 1

3

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.