Sql 2008 R2 Trigger - After update on particular field
Posted on 2013-01-18
I am wanting to send db_mail when my field 'Status' changes value.
My trigger is as below
create TRIGGER [dbo].[SupportCallEmail]
@profile_name = 'SMTPPROFILE', -- Get this value from Server configuration
@recipients = 'SUPPORT@COMPANY.COM',
@subject = 'Change in Record Statsus',
@body = 'status updated'
The trigger does work but seems to work on any field change, not just the 'Status' field
with thanks in advance