• Team,

    I got error as fallows.for reorganizing index.

    Executing the query "ALTER INDEX [PK_ume] ON [dbo].[ume] REORGANIZE WITH ( LOB_COMPACTION = ON )

    " failed with the following error: "A severe error occurred on the current command. The results, if any, should

    be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,

    parameters not set correctly, or connection not established correctly.

    For the Cleanup task Errror MSG:

    Executing the query "EXECUTE master.dbo.xp_delete_file 1,N'',N'txt',N'2009-12-22T01:28:11'

    " failed with the following error: "Error executing extended stored procedure: Invalid Parameter". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.