Post reply

sql smtp

  • August 16, 2011 at 3:00 am

    #242150

    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

    #1369016

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply