sp_blitz script not working on Azure sql database [closed]

Posted on

Question :

sp_blitz script not working on Azure sql database

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

Answer :

It is not compatible. Azure doesn’t expose all the dynamic management views that we get in the boxed product.

take a look here:

https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/1970

Leave a Reply

Your email address will not be published. Required fields are marked *