title: After insert trigger causing table lock
body: <p>I am facing a table lock problem due to trigger. In my case, I have to migrate the data from one server to another server, which needs to be done via web application. I have wrote a stored procedure to insert the data (into 9 tables) from source server/database to target server/database.</p>
  
  <ul>
  <li>User selects the required Employee Name and click on the Migration Button. On clicking migration button, Employee ID stores in a table (<strong>Table A</strong>).</li>
  <li>There is a trigger on this table, which used to call stored procedure.</li>
  <li>This stored procedure used to insert Employee data into 9 tables, based on the provided Employee ID.</li>
  <li>When I inserted the 10 rows to <strong>Table A</strong>, then Stored procedure calls for first row and wait until the accomplish of execution of stored procedure for first employee.</li>
  </ul>
  
  <p><strong>Problem Facing:</strong> </p>
  
  <ul>
  <li><p>Due to this trigger, I am unable to fetch data from those 9 table, util the accomplish of execution of stored procedure for first employee. <strong>I need to avoid this table lock during the process.</strong></p></li>
  <li><p>Also, I want to execute all trigger in parallel, not one by one.</p></li>
  </ul>
  
  <p>Please provide the some solutions to my problems.</p>
  
  <p>Thanks in advance.</p>
  
  <p>Sandy</p>