• Lowell (12/20/2012)


    UPDATE

    SET [col] = [col]

    Seriously? that is the trigger body? updating the column to itself, with referencing the INSERTED virtual table?

    It's not the trigger body... is the sql statement to fire the trigger on the table...

    Try changing the AFTER INSERT, UPDATE to FOR INSERT, UPDATE.

    The UPDATE table SET col = col should fire the trigger, I use it often when I want to do exactly what your're trying to accomplish..



    If you need to work better, try working less...