title: What if my trigger fails after an update inside a stored procedure?
body: <p>If I have an update inside a stored procedure in SQL Server and the stored procedure runs successfully, however, the trigger for that update fails for whatever reason, will my update be rolled back?</p>