I'm looking for some hints on how to setup an auto email to myself if certain criteria is inserted into a certain table in a certain field so I can monitor if certain data is not correct. For example I have a code that is required to go into a Sale Analysis field, if certain rules aren't followed then a default value goes in. I want to be able to know if this happens.
Presumably I can use something like xp_SendMail and a trigger. Obviously keeping the over head down is also a requirement.
Thanks in advance.
Scott