hi all,<BR> I have a trigger on employee table for update statement.My stored procedure updates the employee table and trigger fires but unfortunately trigger fails.How <BR>can i know from my stored procedure that trigger is failed or not.Depending on the trigger <BR>condition i got to do some other action in stored procedure.I tried @@error in my stored procedure but it is not giving the error condition for my trigger.If anybody knows the answer, please help me. <BR><BR>Thanks <BR>elena