• With the trigger code there, that's not possible. That trigger will write into the audit table the rows which were affected by the delete with the host name and user name of the person who ran the delete.

    Maybe the problem's in the update trigger?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass