StackOverflow says you need to set a Database Context when executing it inside an SP
http://stackoverflow.com/questions/658780/passing-stored-procedure-to-sp-send-dbmail Cheers, Judah On Wed, Sep 7, 2011 at 9:17 AM, C. Hatton Humphrey <[email protected]> wrote: > >> 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? > > Since the call was made from the same query window I would assume so. > Unfortunately the error message I'm getting is much less than helpful! > > Thanks for the reply, > Hatton e: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:342292 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
