error on triggar

hi all

i have a nested triggars one of them make an error
so that all the affected are rollback
i want to continue even there are an error

is there a solution
thanksdo you know what the error is that's on the trigger? And do you use transactions? That might be a good check.

It's highly suggested to fix the errors, and not "expect" the errors to occur.

However, you can SET ANSI_WARNINGS OFF, and that may just do the trick.|||the error on arithmitic operation devition by there
i try to use a transaction but it dosen't remove the error from being raise
i recive the folowing error

Server: Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

and then the statment is terminated|||SET ARITHABORT OFF
SET ARITHIGNORE OFF
GO

That will ignore the error, but It's highly recommended that you fix that problem rather than bypass it with this. One way would be to check for the denominator to be anything other than 0.|||thanks it works