You are better off staging the data and processing it in a separate process whether he is Service Broker or another option.Something I do not recall seeing mentioned is that you can do a Select Into temp_table from inserted\deleted then access that temp table in a stored procedure called from the trigger where you can do some set-based processing, of course he is only necessary if you want to en