• Please post the entire trigger code, the table schema, sample table data, the update(s) you fire and the expected action by the trigger.

    NOTE: I get VERY twitchy when I see variables like that in triggers. It is very likely that your trigger can only process one row, and that is something I have seen a client go out of business for (despite the fact that I TOLD them they were going to go out of business)!!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service