Post reply

Send emails through SQL Server

  • August 1, 2003 at 10:02 pm

    #160543

    How can I send and receive emails from my SQL Server. I need to send a mail immediatly after inserting a customer record into a table. Please help me getting through it.

  • August 2, 2003 at 8:08 am

    #468309

    take a look at this link: http://www.sqlservercentral.com/columnists/sjones/sqlmailresources.asp. Also look-up xp_sendmail from BOL.

  • August 5, 2003 at 8:51 am

    #468676

    The best way to send mail when a customer record is inserted is using a INSERT TRIGGER and xp_sendmail within it with appropriate parameters. You could use variables and queries to dynamically build the message. Look up the SQl Books Online for the syntax.

    Have a good one

    -Sravan

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

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