Post reply

Sending mails from SQL Server 2005

  • October 13, 2008 at 8:31 am

    #194553

    Dear All,

    I wanna send mails from SQL Server 2005 when a row is inserted in my ORDER table. Can anyone please tell me how can I do it..?

    Thanks in advance.

    Santhosh Nair.

  • October 13, 2008 at 10:29 am

    #884264

    Configure database mail on the server and create a trigger in the table. Add the code to send an email using Database Mail. This article might help you to configure and understand database mail. http://www.databasejournal.com/features/mssql/article.php/3626056

    Database mail uses Service Broker and the email is sent asynchronously. Hence it does not add much overhead to the trigger.

    .

  • October 15, 2008 at 12:49 am

    #885039

    Thanks a lot, It's done successfully.

  • November 5, 2010 at 11:09 pm

    #1247391

    Hello,

    Can you explain me how to Configure database mail on the server ?

  • November 6, 2010 at 11:23 am

    #1247403

    npulsezone.zone (11/5/2010)

    Hello,

    Can you explain me how to Configure database mail on the server ?

    Here are two great resources that should help you getting started:

    link 1

    link 2


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

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