SendMail attachment size limit?

  • Does anyone know if there is a size limit for the attachments you can send with a SendMail Task?

    I can't seem to find anything in BOL, though I could just be using the wrong search terms.  Thanks in advance..

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • I think I found the limit to be 1,000,000 bytes.  That was the error I received while trying to send the results of a query to my manager using send_dbmail.

  • Darnit...

    I was hoping that wasn't the answer.  I ran into that problem this morning with a T-SQL send mail proc that doesn't use DBMail.  So I was hoping switching my package task to use SENDMAIL would fix that.

    Darn, Darn, darndarndarn...

    Oh, well.  Thanks, Lynn.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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