5CHDV Posted October 22, 2007 Share Posted October 22, 2007 While browsing the MSDN library about the behaviour of triggers with rollback transaction commands i found the following:german msdn documentation july 2006 - link:ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.de/tsqlref9/html/6882c5bc-ff74-476a-984b-164aeb036c66.htmBeim Ausgeben von ROLLBACK TRANSACTION in einem Trigger erfolgt Folgendes: Der Trigger setzt die Ausführung aller verbleibenden Anweisungen nach der ROLLBACK-Anweisung fort. Wenn durch eine dieser Anweisungen Daten geändert werden, wird für die Änderungen kein Rollback ausgeführt. Es werden keine geschachtelten Trigger durch die Ausführung der verbleibenden Anweisungen ausgelöst.which means that nested triggers will not be executed after a rollback command within the trigger.when trying the following example:alter trigger tins on a after insert as raiserror('tins!', 16, 1) rollback transaction update a set x = 0goalter trigger tupd on a after update as raiserror('tupd!', 16, 1)goinsert into a values(3,4)the output is the following:Meldung 50000, Ebene 16, Status 1, Prozedur tins, Zeile 2tins!Meldung 50000, Ebene 16, Status 1, Prozedur tupd, Zeile 2tupd!which isnt really what we expected.Bug ? or Documenation Bug ? Link to comment Share on other sites More sharing options...
tain Posted November 19, 2007 Share Posted November 19, 2007 Your odds of getting assistance increase if you translate the German to English for us.Good luck Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now