<div>
if the procedure is like this:<br />
<br />
&nbsp; begin transaction<br />
&nbsp; &nbsp; insert into table ... <br />
&nbsp; rollback<br />
<br />
and the table has a insert trigger, the trigger WILL fire
</div>


if the procedure is like this:

  begin transaction
    insert into table ...
  rollback

and the table has a insert trigger, the trigger WILL fire

<div>
would the rowcount from the inserted table work to identify whether the stored procedure's insert had indeed been successful?
</div>


would the rowcount from the inserted table work to identify whether the stored procedure's insert had indeed been successful?

<div>
<div class="content wysiwyg-content">
If a Stored Procedure contains an insert statement wrapped in a transaction and that transaction is rolled back in the procedure, does the after trigger still fire? Or is the trigger only called upon the commit statement?<br />
<br />
Thanks.
</div>
</div>


If a Stored Procedure contains an insert statement wrapped in a transaction and that transaction is rolled back in the procedure, does the after trigger still fire? Or is the trigger only called upon the commit statement?

Thanks.

After Insert Trigger &amp; Rollback

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

After Insert Trigger &amp; Rollback

After Insert Trigger & Rollback