Re: Mail from sql?

mostard 10-12-2005, 8:01 AM
Greetings,

What tools, if any, do we have available to send mail from withing our usp's?

Thanks,
M.

JPaul 03-19-2007, 11:50 AM
Good question. Anyone out there doing this with sql and wh4l?

JPaul 03-19-2007, 1:13 PM

I just did some poking around at the xp_sendmail procedure in a database I uploaded to the wh4l server and I got the following error:

EXECUTE permission denied on object 'xp_sendmail', database 'mssqlsystemresource', schema 'sys'.

Not sure if there's any more options.

webhost4life.com