• Check sys.indexes in every database where the name has -

    IF @frag < 30.0

    SET @command = N''ALTER INDEX ['' + @indexname + N''] ON ['' +@DBname+ N''].[''+ @schemaname + N''].['' + @objectname + N''] REORGANIZE'';

    IF @frag >= 30.0

    SET @command = N''ALTER INDEX ['' + @indexname + N''] ON ['' +@DBname+ N''].['' + @schemaname + N''].['' + @objectname + N''] REBUILD'';

    IF @partitioncount > 1

    SET @command = @command + N'' PARTITION='' + CAST(@partitionnum AS nvarchar(10));

    EXEC (@command);

    -- PRINT N''Executed: '' + @command;

    END;

    Added extra [] around the db schema object in case anything else has special characters in the name.