Post reply

sysmail_attachments table size incorrect

  • November 15, 2010 at 2:06 pm

    #142625

    I ran maintenance on this mail table with sysmail_delete_mailitems_sp but it does not report the size decrease given now that it is empty for the most part. Anyone know if something has to done in addition to correct this?

    running sp2.

    tried update stats.

    checkdb.

    checktable

    Thanks

  • November 15, 2010 at 10:09 pm

    #1251088

    Did you try running DBCC UPDATEUSAGE?

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • November 16, 2010 at 6:46 am

    #1251306

    yes, but no luck. had a lot of varbinary in there from attachments.

  • August 16, 2011 at 8:45 am

    #1369123

    hi,

    i had this same problem, the table size would not go down, and i could not shrink the file size despite there being no records in the table.

    as a last resort, i scripted the table out, then deleted and recreated it, which seemed to work.

    Ben.

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

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