Permissions differences to the attachment files/file system between the direct call and the sp?
do they both have the same permission access to the attachment files? On Wed, Sep 7, 2011 at 12:05 PM, C. Hatton Humphrey <[email protected]> wrote: > > I'm having a "bang head here" day trying to get sp_send_dbmail working > in SQL 2005 with file attachments. Long story short, I'm working on > an internal "mass mail" system and while my test emails with > attachments work (by calling just the sp), building the exact same > call inside a stored procedure doesn't. I get an "Attachment file is > invalid" error. > > I'm almost to the point where I want to ditch the SQL mail solution > and write another Windows service to process this... anyone have any > suggestions on how to get this cluster to work? > > Thanks... I need an aspirin now! > > Until Later! > C. Hatton Humphrey > > No trees were killed in the sending of this message, but a large > number of electrons were terribly inconvenienced. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:342290 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
