Post reply

Could not proceed with index DDL operation on table...

  • July 11, 2008 at 2:57 am

    #122405

    Hello,

    I have a problem with an SP (SP_Rename) wich rename a big table (80 mill of rows). This task is running on a SISS Package. The next task try to create a new index on the same table but i receive the message:

    "Could not proceed with index DDL operation on table 'HIS_CUENTAS_FONDO_PATRIMONIO' because it conflicts with another concurrent operation that is already in progress on the object"

    somebody know the solution for this issue?

    Thanks!

  • July 18, 2008 at 6:26 am

    #844966

    Use Transaction Isolation Levels

    If that doesn't work then seperate them into two seperate tasks

    Regards
    Venkat
    http://sqlblogging.blogspot.com[/url]

  • July 18, 2008 at 6:48 am

    #844977

    Last time I saw that message it was because an online rebuild of the index wqas occurring at the same time. Check that.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply