login about faq

I am using SQL Server 2012 Web edition, and I am trying to read a POP3 mailbox from T-SQL, but I seem to be limited to 8000 bytes for the body of the email. If the email is > 8000 bytes I get nothing. I think at this point I would be happy with even the first 8000 bytes!

I have tried using VARCHAR(MAX) for the Body var, but that does not seem to work either.

All of your sample code seems to leave out the “Body” property entirely.

asked Sep 23 '13 at 10:09

chilkat's gravatar image

chilkat ♦♦

Local variables in SQL are limited in the number of bytes they can contain. Use a temp table to get long string results:

    -- Fetch a longer property string into a temp table:
    DECLARE @tmp TABLE (emailBody ntext)
    INSERT INTO @tmp EXEC sp_OAGetProperty @email, 'Body'

answered Sep 23 '13 at 10:12

chilkat's gravatar image

chilkat ♦♦

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: Sep 23 '13 at 10:09

Seen: 1,962 times

Last updated: Sep 23 '13 at 10:12

powered by OSQA