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 - 2005-09-21 : 22:41:21
|
| Pankaj writes "Hi!Suppose I have a trigger and it fails(Non Fatal) due to some reason.So my question is : how do I know from my application that the trigger fails ?? Also how do I catch the ERROR Number from the application. We can use RAISERROR in Trigger.Application using : VB, SQL Server.Thanks in advance, for giving the answer.For GarthI read the two articles "An Introduction to Triggers", but no where you have written how to handle ERROR in trigger. If you can find time and answer my query, that will be great help for me.Regards,Pankaj" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Handling Error in Trigger 