The latest version of the solution is not compatible with AZURE SQL (PaaS)

The following stored procedures have issues with AZURE SQL:
- IndexOptimize
- DatabaseIntegrityCheck

These are pointing to SQL objects that do not exist in Azure, for example:
- sys.dm_os_host_info
- sys.availability_groups
- sys.availability_replicas
- sys.master_files
- dbo.[Queue]
- dbo.QueueDatabase

I temporarily solved my problem by using an old version I have from the year: July 19, 2015.


Locate the IndexOptimize and DatabaseIntegrityCheck stored procedures in the repository and compare their referenced SQL objects with those available in Azure SQL. Start by reproducing the failure against Azure SQL and inspect the listed objects, including sys.dm_os_host_info and sys.availability_groups. Done means both procedures run without referencing unavailable objects, with coverage for the affected paths.

Written by the indexing model from the issue text.