The problem is solved. The problem was a function called in the view that TRIM strings, and the return variable was set to varchar(2000).

Thanks for the help.

Best Regards,

It works if I change the declarations to:

@vPrimeiroPSubString bigint,

@vSegundoPSubString bigint,

Best Regards,

Hi,

Thanks for the reply.

I need to send and e-mail if a field is not null. If on insert or update the field is not null the trigger should fire.

How...

Lowell (7/16/2009)

---

it should work with some minor tweaks:

after you've done the DECLARE @acumul_error varchar(100) or whatever it is, you need to initialize it as an empty string:

SET @acumul_error =''

in...