January 19, 2008 at 1:28 pm
Just in time for the release of 2008, we upgraded to 2005 last night. Other than some security issues, it did go fairly smooth.
However, I am running into a problem and I am out of ideas on how to fix it. Granted lack of sleep is taking a toll.
One of the problems that we had was that SQLMail no longer seemed to recognize the Outlook Mail Client running on the machine. I thought, no big deal, it can't be that hard to change over the 20 or so reports to use Database Mail instead.
I enabled Database Mail, set up a profile, and successfully fired off the first couple reports.
My problems turn up when I send off a report that includes an attachment. The e-mail shows up in my Inbox, but the attachment is not there.
There are no error messages in the logs. It seems like it must be a security issue of some sort, but I am just out of ideas.
Here is the call to Database Mail:
exec msdb.dbo.sp_send_dbmail 'sqlmail' ,
@recipients = 'me@mydomain.com',
@subject = 'Daily Model 400 Outbox Message Count',
@BODY = 'Outbox Message Count Report is attached.',
@query_attachment_filename = 'c:\reports\39EEFD51-88B6-4A45-8630-440303DEB696.PDF'
The report is there on the server, just not in the e-mail.
Any help would be much appreciated!
Scott
January 19, 2008 at 2:37 pm
Try using @file_attachments = 'file_attachments' parameter instead.
When you want the results from an @query parameter attached as a file you'd use @attach_query_result_as_file = 1 along with @query_attachment_filename.
January 19, 2008 at 3:37 pm
That was the problem!
Thanks for your help.
Scott
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy