Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Trigger with RAISERROR RE: Trigger with RAISERROR
e.alakhras
Valued Member
Points: 73
More actions
September 13, 2016 at 6:05 am
#1900509
Perhaps better to rollback before raiserror.
You don't know what an error handler would do, especially time wise.
Releasing a transaction at the earliest will release locks, thus, wait at other connections.