MicrosoftYochanan_Rachamim can you tell me how to modify the script for this? I can't seem to get past this error.
-----------------------
set operation = all
set mode = smart
set LogToTable = 1
-----------------------
Get index information...(wait)
---------------------------------------
Index Information:
---------------------------------------
Total Indexes: 737
Average Fragmentation: 1.22889
Fragmented Indexes: 1
---------------------------------------
Get statistics information...
---------------------------------------
Statistics Information:
---------------------------------------
---------------------------------------
Start executing commands...
ALTER INDEX [PK_gnEmailPrev] ON [dbo].[gnEmailPrev] REBUILD WITH(ONLINE=ON,MAXDOP=3);
FAILED : 2725An online operation cannot be performed for index 'PK_gnEmailPrev' because the index contains column 'RecipList' of data type text, ntext, image or FILESTREAM. For a non-clustered index, the column could be an include column of the index. For a clustered index, the column could be any column of the table. If DROP_EXISTING is used, the column could be part of a new or old index. The operation must be performed offline.
Msg 50000, Level 16, State 1, Procedure AzureSQLMaintenance, Line 269 [Batch Start Line 284]
Script has errors - please review the log.
Completion time: 2020-09-15T12:00:21.5813261-05:00
