title: basic trigger lock issue
body: <p>I have one question regarding trigger.
  The scenario is like this</p>
  
  <pre><code>Create Procedure
  begin
      Insert into XYZ (a) values (b)
  end
  </code></pre>
  
  <p>Now i have placed the trigger on <strong>INSERT - AFTER</strong> on table XYZ.
  In that trigger there is business logic which takes 2-3 seconds to execute it, business logic is performed against other database table <strong>not on the XYZ table</strong></p>
  
  <p>So what i need to confirm here that once INSERT is been done, then the table XYZ will be ready to do insert for another records or it will be locked until the trigger is completed?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>I have done some more research on this issue and explain it below
  In the INSERT - TRIGGER, i have put the my business logic and also below line</p>
  
  <pre><code>WAITFOR DELAY '00:01'
  </code></pre>
  
  <p>Now when i try to execute the above SP, the SP was not completed for 1 minues (as i have specified the delay of 1 minute in the trigger) and table XYZ was also locked during this period.</p>
  
  <p>So this brings me to the conclusion that trigger does LOCKS the table even if you are not using the same table in the trigger. Am i right? Does anyone has different opinion here?</p>