title: Are Sql Triggers synchronous or asynchronous?
body: <p>I have a table that has an insert trigger on it. If I insert in 6000 records into this table in one insert statement from a stored procedure, will the stored procedure return before the insert trigger completes?</p>
  
  <p>Just to make sure that I'm thinking correctly, the trigger should only be called (i know 'called' isn't the right word) once because there was only 1 insert statement, right?</p>
  
  <p>My main question is: will the sproc finish even if the trigger hasn't completed?</p>