MicrosoftI had to set the script to do offline only for it to run. The script completed but it didn't defragment. Current fragmentation is still at 99.13%.
id OperationTime command ExtraInfo StartTime EndTime StatusMessage
2 2020-09-15 12:06:33.7869014 ALTER INDEX [PK_gnEmailPrev] ON [dbo].[gnEmailPrev] REBUILD WITH(ONLINE=ON,MAXDOP=3); Current fragmentation: 99.13% 2020-09-15 12:06:33.8706769 2020-09-15 12:06:33.8717064 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.
