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 |
|
bvides
Starting Member
1 Post |
 Posted - 2002-04-26 : 18:23:38
|
| We've written an insert trigger that is for auditing purposes, but if the trigger code fails (for whatever reason) we would like the initiating transaction to continue. Is there anyway to make errors in the trigger non-fatal? In other words, we would like to continue processing even if the trigger fails.Thanks in advance. |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-05-17 : 13:42:39
|
quote:
Is there anyway to make errors in the trigger non-fatal?
no, but maybe you can adapt this code to execute the logging dml outside the current transaction.<O> |
 |
|
|
|
|
|
Triggers failing transaction