Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-20 : 09:56:04
|
| George writes "Hi Sean, I am tired of trying to find the solution to this problem.I have been checking for an answer for last 2 weeks thru internet as well as checking in msdn. Please help me. 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 can i know from my stored procedure that trigger is failed or not. Depending on the trigger condition i got to do some other action in stored procedure. I tried @@error in my stored procedure as well as in trigger. What is happening is that once the trigger fails that it rollbacks the transaction(it seems that it is exiting from stored procedure and trigger). The @@error in both trigger and stored procedure is not executing. It would be great if you can help.ThanksGeorge" |
|
|
|
|
|
how do i know from my stored procedure whether trigger failed or not