Fun with Transactions - Part III

Question

Fun with Transactions - Part III

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

JF1081 (9/21/2010)
Would COMMIT TRAN OuterTran without the use of COMMIT TRAN InnerTran commit both transactions?

Yes it does.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

JF1081 SSC Eights! Points: 982 More actions · Answer 2

CirquedeSQLeil (9/21/2010)
JF1081 (9/21/2010)
Would COMMIT TRAN OuterTran without the use of COMMIT TRAN InnerTran commit both transactions?
Yes it does.

Thanks, and I hope I did not just ruin Part IV.