Blog - Tech / Database / SqlServer

I'm very familiar with Oracle and I'm trying to find the comparable code in SqlServer world.  I think I'm confusing myself with the need or not for SET XACT_ABORT ON or BEGIN TRAN or ...

Basically, I am putting a trigger on a base table  'mytable' that upon an insert or update on mytable, to copy two values to another table 'mynewtable'.  I believe I understand how to handle that aspect but want to add error handling such that if the trigger logic fails for whatever reason, I want the insert into the base table 'mytable' to commit regardless and we write a message to another table 'myerrortable'.

Trying to find any solutions on this was onerous.