Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unhappy Unanswered: SQL Email Trigger

    Hi,
    I am looking for a SQL trigger that will send email notification to a mailing list whenever a folders contents have been changed.
    Can anyone help on this as I have little to no experience with SQL??

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    I am looking for a SQL trigger that will send email notification to a mailing list whenever a folders contents have been changed.

    Triggers are for table changes, not folder changes. You should set up a job that looks at the contents of the folder. If the contents have changes, use xp_sendmail to notify the appropriate authorities.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •