Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


sql mail

Posted on 2014-08-22
Medium Priority
Last Modified: 2014-08-24
Hi experts:

Where I can set to the size of the attachment is over 1MB when sending an email through SQL.
Question by:enrique_aeo
1 Comment
LVL 75

Accepted Solution

Anthony Perkins earned 2000 total points
ID: 40279989
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question