referes to deleted and inserted tables, does MSSQL actually delete a row and then insert a row with then new/altered values ?
Reason am asking, some delete triggered seem to be fired by the update action - is that normal or third-party -softewre annomally ?