Send mail from sql server

Wrox Programmer Forums

		Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
Send mail from sql server

SQL Server 2005 General discussion of SQL Server *2005* version only.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

July 14th, 2008, 12:18 AM

Manoah

Manoah is offline

Authorized User

Join Date: Jul 2008

Posts: 26

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Send mail from sql server

I need to send mail from a table when it gets updated using stored procedure. How can I do it?

Old

July 15th, 2008, 01:32 AM

jackyhui

jackyhui is offline

Registered User

Join Date: Mar 2007

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Default

You may be able to use trigger to check whether the column is updated. If it is updated, send email in the trigger.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sending mail from sql server	pady123	SQL Server 2005	0	October 17th, 2008 01:58 AM
Send mail and attachments with PHP mail function	Lofa	Beginning PHP	1	June 2nd, 2008 03:24 PM
SQL SSIS Send Mail Task	mstoler	SQL Server 2005	0	August 8th, 2006 07:35 AM
Using CDONTS to send SQL server errors	kevorkian	SQL Server ASP	1	April 22nd, 2005 06:15 AM
Question1:How to send mail through proxy server?	Edward King	Pro JSP	0	December 19th, 2003 04:21 AM