August 16, 2011 at 3:00 am
Hi,
Is it possible to send mail from sql without using sql smtp.
if yes Please provide the solution
Thanks in advance
August 16, 2011 at 5:48 am
you'd need to call a either a third party dll like we used to have to in SQL2000 (via cmdshell and sp_oaCreate)
I used to use a dll from AspEmail a longtime ago, so i could send from both a asp web page and also from within SQL Server.
or create a CLR to do the work in .NET; it's very easy to send an email in .NET, lots of examples out there.
There are a huge number of advantages to using the built in service with msdb.dbo.sp_send_dbmail , the primary one is ease of use.
Is there a specific reason you want to avoid it?
Lowell
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply