Post reply

Transaction Rollback Trigger

  • August 15, 2003 at 7:47 am

    #162132

    I have a database with a table that stores company records. After an update, I want the company to receive an email with a link that they must click on to confirm the changes. Maybe a transaction rollback trigger. I have seen this done before. Does anybody know of an article?

  • August 16, 2003 at 7:47 am

    #470183

    I dont think you want a trigger - that could be an extremely long running transaction. A better/simpler approach is to save the changes in a separate table, once you get the approval, run the final update. Or decide that maybe you're better off to make the change and send the notification afterward, that way if the change is incorrect/incomplete they'll know they need to make a second change.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • August 17, 2003 at 3:45 am

    #470207

    Agree with Andy Warren suggestion or add a column confirmed(Yes,No,Maybe,etc.).

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply