Can we attach a file which is stored as base64 string in a table column directly into sp_send_dbmail without using Server Path method ?
May 03, 2017 at 07:53 AM
May 03, 2017 at 05:49 AM
I don't believe you can attach a string as an actual file attachment within the email. You could however just append it to the body of the message since it's a string.
May 03, 2017 at 12:53 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: May 03, 2017 at 07:53 AM
Seen: 52 times
Last Updated: May 03, 2017 at 12:53 PM
Use Expression in sp send_db_mail attachment
Bulk Insert SQL 2005 - Unix file not working
Update as400 table using excel file
File Transfer in SSIS
SFTP in SSIS
Storing result set to a text file
Bad file mode
file group is running out of space
Sharepoint - Datafiles - MaxSize
SSRS Email File Size