xp_readmail message body > 8000

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Adam Stretch (adam_stretch_at_skyservice.com)
Date: 05/19/04 

Date: 19 May 2004 11:07:20 -0700

Hello all,

I'm trying to create a TSQL mail reader solution that will parse out
emails in the SQL mail inbox, load them to a DB table, and then remove
them from the inbox. I'm still in the planning process, but I have
seen several postings regarding the 8000 char limit. Infortunately,
all of the postings I've found on the subject have no replies. The
emails will be more than 12,000 chars on average and I need to get all
of the email body.

The xp_readmail example in BOL didn't provide quite enough infomation.

I'd like to load the entire email body into a text data type column.
In a TSQL script, I can't use a text data type local variable.

Any ideas or info would be greatly appreciated (on the 8000 char limit
OR on the process in general).

Thanks in advance,

Adam

Relevant Pages

  • xp_readmail message body > 8000
    ... I'm trying to create a TSQL mail reader solution that will parse out ... emails in the SQL mail inbox, load them to a DB table, and then remove ... I'd like to load the entire email body into a text data type column. ...
    (microsoft.public.sqlserver.programming)
  • Re: exchange -
    ... i cant seem to sycn emails with my server even if i am connected to teh ... >> synchronization software. ... >> find a load of info on it and how great it is but no where that says ...
    (microsoft.public.pocketpc.activesync)
  • back up PST incomplete ?
    ... First off system had a new harddrive fitted with new copy of windows XP ... New drive has fresh copies of everything on it but when I went to load ... all my emails seem to be ... Now when I went to set up my mail accounts one set for one of my web ...
    (microsoft.public.outlook.installation)
  • Re: Were we an open relay, NDRs or glitch? SBS 2003 Exchange
    ... > had queues with thousands of emails in them. ... There were a load of identical emails going to the ... > So i'm thinking if we were an open relay we'd be sending emails all ...
    (microsoft.public.windows.server.sbs)
  • Re: Custom CSS in Mail
    ... Paolo Cordone wrote: ... whatever fonts the designers of HTML-rich emails have chosen. ... I have the option to load images from remote servers ...
    (comp.sys.mac.comm)