sql mail

enrique_aeo used Ask the Experts™
Hi experts:

Where I can set to the size of the attachment is over 1MB when sending an email through SQL.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012
You said SQL Mail (which is deprecated and uses MAPI), I suspect you mean SQL Server Database Mail (which uses SMTP).  If so you are looking for the Maximum File Size.  This is how you change it:
SQL Database Mail - Send Emails with Attachment

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial