Welcome to Webhost4life Forum Sign in | Join | Faq

MSSQL

Started by mostard at 10-12-2005 8:01 AM. Topic has 2 replies.

Print Search
Sort Posts:    
   10-12-2005, 8:01 AM
mostard is not online. Last active: 10/12/2005 11:00:10 PM mostard

Top 500 Posts
Joined on 10-12-2005
Posts 1
Mail from sql?
Reply Quote
Greetings,

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

Thanks,
M.


   Report 
   03-19-2007, 11:50 AM
JPaul is not online. Last active: 3/22/2007 9:49:24 PM JPaul

Top 100 Posts
Joined on 03-20-2007
Posts 3
Re: Mail from sql?
Reply Quote
Good question.  Anyone out there doing this with sql and wh4l?
   Report 
   03-19-2007, 1:13 PM
JPaul is not online. Last active: 3/22/2007 9:49:24 PM JPaul

Top 100 Posts
Joined on 03-20-2007
Posts 3
Re: Mail from sql?
Reply Quote

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.

 


   Report 
Webhost4life Fo... » Database Relate... » MSSQL » Re: Mail from sql?

Powered by Community Server, by Telligent Systems