locked
Where are attachments stored in the database? RRS feed

  • Question

  • I see from other similar questions posted they're stored as blobs on the AnnotationBase table.  Is this where all attachments are stored?  are they stored as compressed strings on the documentBody column?
    Thursday, August 26, 2010 4:48 AM

Answers

All replies

  • Looks like email attachments are on the ActivityMimeAttachment table.  Anything else?  I need to make sure I get them all.

     

    Thanks,
    Matt

    Thursday, August 26, 2010 5:00 AM
  • Just take a look at the database model.
    Gruß Carsten Groth http://carstengroth.spaces.live.com
    Thursday, August 26, 2010 6:43 AM
  • email attachement are stored in ActivityMimeAttachment table
    but
    notes attachement will be stored in annotationbase table

    so you will need to look both these table for the same..

    HTH..


    MayankP My Blog My twitter
    Thursday, August 26, 2010 9:51 AM
    Answerer
  • And they are stored as Base64 string
    MSCRM Bing'd - http://bingsoft.wordpress.com
    Thursday, August 26, 2010 9:54 AM
    Moderator