• Instead of triggers you can use OUTPUT Parameter, Like Below.

    --- For Insert ---

    INSERT INTO TableName

    OUTPUT INSERTED.* INTO ToTableName

    VALUES

    ---

    --- For Update ---

    UPDATE TableName SET ColumnToupdate

    OUTPUT deleted.* INTO ToUpdTableName

    ---

    --- For Delete ---

    DELETE FROM TableName

    OUTPUT deleted.* INTO ToDelTableName

    WHERE

    ---

    I suggested using OUTPUT because your trigger is ALTER INSERT, UPDATE, DELETE it mince you want to update this after the data inserted/updated/deleted.