Using SQL2000.
When a record is added into a particular table with one of 2 specific codes I would like SQL Server to send out an email to two recipients.
I've browsed Google and found most threads/articles confusing and over complicated (they inc. creating tables etc which I don't need).
The email which goes out will need to include data stored in several fields for that record.
Any advice or Urls would be greatly apprecited
I should add I'm not sure how to create the trigger (I know where to create it!) or the code to allow the email!
When a record is added into a particular table with one of 2 specific codes I would like SQL Server to send out an email to two recipients.
I've browsed Google and found most threads/articles confusing and over complicated (they inc. creating tables etc which I don't need).
The email which goes out will need to include data stored in several fields for that record.
Any advice or Urls would be greatly apprecited
I should add I'm not sure how to create the trigger (I know where to create it!) or the code to allow the email!