title: SQL Update via triggers without database locking
body: <p>Is there a way to update a record  in an audit table (via triggers) without that record being locked due to the update which fired the trigger was inside a transaction.</p>
  
  <p>So we have a Users table and a trigger that fires on insert, update, delete and logs the changed values to some Audit table, however i do not want the audit table to be locked preventing other triggers from firing which do actions on the audit table.</p>
  
  <p><strong>edit:</strong> just to clarify, the issue I have is that multiple tables report to the same audit table via different triggers, so an update to one table locks all the other tables from being updated. As for the concerns about what if transactions roll back, this is not such a concern as the audit table is there just for change tracking and if the record rolls back it is not an issue if the audit table does not roll back.</p>
  
  <p>I have thought of a way it might work but I do not know if this is possible (or how to do it), is there a way have a trigger use a new connection instead of the one that was initially called?</p>