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.

Advertisements

About nijamkhan

I am simple Hardworking,and i would like improve the Knowledge time by time
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s