Increase Size of File Attachment in SQL Server.
Microsoft SQL Server provides attachment when you sent an email from your application.
By default maximum size for attachment is 1000000 bytes. Its less then 1 MB, we can increase this size by following the below steps.
Step1 : Right click on “DatabaseMail” and select “Configure Database Mail”.
Step2 : On “Select Configuration Task” window select “View or Change system parameter” and click on “Next”.
Step3 : You can see “Maximum File Size (Bytes)” Parameter, By default it is 1000000 bytes and i have increased by 10000000 bytes and click on “Next”.
Step4 : Check changed parameter value on the “complete the wizard” and click on “Finish”.
Step5 : Check configuration status on “Configuring” window and “Close” the window.
Now you can able to send attachment up to 10 MB of size.
Thanks & Regards,
Nirav Gajjar