Thursday, March 22, 2012

email trigger

Hello

Can you setup a trigger to mail some one when a record is updated in SQL server 2005?

If you can, can anyone help me?


C

Yes, you can call a extended procedure 'xp_sendmail' in an update trigger. The following article shows an example:

http://msdn.microsoft.com/library/en-us/architec/8_ar_da_1tup.asp?frame=true

sql

No comments:

Post a Comment