am modificat si ExecTran pe acelasi principiu
begin try
begin tran
.................cod mult................
commit tran
end try
begin catch
if @@trancount > 0 rollback tran
declare @ERROR_MESSAGE nvarchar(4000),
@ERROR_SEVERITY int
select @ERROR_MESSAGE = ERROR_MESSAGE() + ' in SP: ' + isnull(ERROR_PROCEDURE() + ' line ' + convert(nvarchar, ERROR_LINE()), ''),
@ERROR_SEVERITY = ERROR_SEVERITY()
raiserror(@ERROR_MESSAGE, @ERROR_SEVERITY, 1)
end catch
ca sa fiu sigur ca are severitate intre 11 si 19 nu e mai bine sa folosesc
raiserror(@ERROR_MESSAGE, 16, 1)
in loc de
raiserror(@ERROR_MESSAGE, @ERROR_SEVERITY, 1) ?