Increase Size of File Attachment in SQL Server

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”.

Increase Attachmet 1
Step2 : On “Select Configuration Task” window select “View or Change system parameter” and click on “Next”.

Increase Attachment 2
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”.

Increase Attachmet 3
Step4 : Check changed parameter value on the “complete the wizard” and click on “Finish”.

Increase Attachmet 4
Step5 : Check configuration status on “Configuring” window and “Close” the window.

Increase Attachmet 5
Now you can able to send attachment up to 10 MB of size.

Thanks & Regards,
Nirav Gajjar