sp_send_dbmail allows you to send emails with attachments. However by default, Database Mail limits file attachments to 1 MB per file.
You can configure database mail to allow larger sizes.
Expand the Management tab, right-click on Database Mail,
Click on Configure Database Mail.
Select "View or change system parameters"
"Maximum File Size (Bytes)" is the option you can change to configure the attachment size.
Thursday, March 14, 2013
Subscribe to:
Posts (Atom)
