Just remember that a SQL Server trigger fires ONCE no matter how many rows are affected by the query - one, five, or even zero. After you UNION the Inserted and Deleted columns, it may not be enough to just refernce @@ROWCOUNT.