Viewing 4 posts - 1 through 5 (of 5 total)
That's only true if you run in Implicit Transaction Mode (SET IMPLICIT_TRANSACTIONS ON).
Otherwise you have to execute a BEGIN TRAN to start a transaction.
October 26, 2005 at 3:30 am
There is no transaction, according to the question. You are coming into the trigger without being in the context of a transaction. In other words, there was no "begin transaction" executed...
October 20, 2005 at 1:47 am
Please read my post. According to the text of the question, we aren't running in a transaction. No transaction = no rollback.
October 19, 2005 at 1:22 am
The question didn't state that the statement that caused the trigger to fire was running inside a transaction.
October 18, 2005 at 5:13 am
Viewing 4 posts - 1 through 5 (of 5 total)