I need help on implementing error handling.

I have created below trigger which calls one store procedure to store audit data. Now I want to catch the error that might occurs...

Thanks for providing good solution.

Before I change datatype from ntext to nvarchar(max), I would like to know the difference between ntext and vvarchar(max).

Thanks,

Ruchir