• Add Set XACT_Abort oFF to the beginning of your trigger. to my knowledge, that is the only thing you can do as a workaround.