I'm definitely no expert, but I think within the usp_AdaptiveIndexDefrag.sql the variable "sqlcmdRI" seems to be declared to short for longer database names.
DECLARE @sqlcmdRI NVARCHAR(100)
My database is named like this: COMPANY_Testing_Result. And so the part
'; SELECT @HasRI_OUT = COUNT(*) FROM sys.index_resumable_operations'
gets truncated at the end.
Changing it to
DECLARE @sqlcmdRI NVARCHAR(200)
Did the trick for me...
I'm definitely no expert, but I think within the usp_AdaptiveIndexDefrag.sql the variable "sqlcmdRI" seems to be declared to short for longer database names.
DECLARE @sqlcmdRI NVARCHAR(100)My database is named like this: COMPANY_Testing_Result. And so the part
'; SELECT @HasRI_OUT = COUNT(*) FROM sys.index_resumable_operations'gets truncated at the end.Changing it to
DECLARE @sqlcmdRI NVARCHAR(200)Did the trick for me...