-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a two part question relating to sending query results as attachments using sp_send_dbmail.
Problem 1: Only basic .txt files will open. Any other format like .pdf or .jpg are corrupted.
Problem 2: When attempting to send multiple attachments, I receive one file with all file names glued together…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi Friends,
When we use sp_send_dbmail to send email with attachment, the attachment gets copied into a folder inside C:\Windows\Temp. As we have many emails to be sent every day, the temp folder grows rapidly. This is the case with SQL Server 2005. We noticed that, with SQL Server 2008, we dont…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
sp_send_dbmail works fine on one server as below:
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'xxxx Mail Profile',
@recipients = 'xxx.com',
@body = 'xxxxxxxx',
@subject = 'xxx - Please do not reply to this email';
But on other server where got same Mail profile setup
throws an error saying it…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
How can I specify the content type of an attachment when sending emails using sp_send_dbmail? The content type is specified as application/octet-stream for Zip, PDF files. But I need to change it to application/zip, application/pdf.
The "file_attachments" parameter takes absolute paths of the attachments…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
I would like all users in database1 to be able to send emails. Can I add DatabaseMailUserRole to the public profile of database1 and will this allow all users to send an email?
Thanks,
>>> More