• I agree with Gail - see if it hurts before bothering with it.

    If it DOES hurt, then I agree with Phil - this is a VERY silly thing for a trigger to be doing. This belongs with the code that actually changes the status of the records!!

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