Post reply

Error occurred while attempting to drop worktable with partition ID 423626411802624.

  • April 19, 2010 at 11:36 am

    #223544

    The SQL Server stopped running, these messages were in the sql logs. Only thing I saw in the event logs

    Could not find an entry for table or index with partition ID 489800837038080 in database 2. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored procedure, or execute DBCC CHECKDB.

    Error occurred while attempting to drop worktable with partition ID 489800837038080.

    I'm running on SP2 and have seen mention of a hotfix that was rolled up in SP2.

    Has anyone had this issue?

  • April 19, 2010 at 11:50 am

    #1154046

    I'd suggest upgrade to at least SP3, if not SP3 + latest Cumulative Update (CU). I know there was a bug recently (in last 12 months) found related to these kinds of errors in TempDB. If you upgrade to the latest SP + CU and still get these, call MS's customer support as it may be a new bug.

    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 2 posts - 1 through 1 (of 1 total)

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