Microsoftgot error when running as exec dbo.AzureSQLMaintenance 'all', @LogToTable=0, @ResumableIndexRebuild=1
-----------------------
set operation = all
set mode = smart
set ResumableIndexRebuild = 1
set RebuildHeaps = 0
set LogToTable = 0
-----------------------
Get index information...(wait)
---------------------------------------
Index Information:
---------------------------------------
Total Indexes: 7
Average Fragmentation: 97.6471
Fragmented Indexes: 1
---------------------------------------
Get statistics information...
---------------------------------------
Statistics Information:
---------------------------------------
Total Modifications: 128
Modified Statistics: 2
---------------------------------------
Start executing commands...
ALTER INDEX [CORRESPONDENCE_REQUEST_PK] ON [UA3_CORRESPONDENCE_MGMT].[CORRESPONDENCE_REQUEST] REBUILD WITH(ONLINE=ON,MAXDOP=1, RESUMABLE=ON);
FAILED : 574RESUMABLE INDEX statement cannot be used inside a user transaction.
UPDATE STATISTICS [UA3_CORRESPONDENCE_MGMT].[CORRESPONDENCE_RESPONSE] ([CORRESPONDENCE_RESPONSE_PK]) WITH FULLSCAN;
UPDATE STATISTICS [UA3_CORRESPONDENCE_MGMT].[HPP_TENANT] ([HPP_TENANT_PK]) WITH FULLSCAN;
Msg 50000, Level 16, State 1, Procedure AzureSQLMaintenance, Line 527 [Batch Start Line 570]
Script has errors - please review the log.
Completion time: 2021-07-02T12:51:01.8000450-05:00
