Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Fun with Transactions - Part I Expand / Collapse
Author
Message
Posted Monday, September 13, 2010 9:31 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:17 PM
Points: 1,381, Visits: 1,774
Comments posted to this topic are about the item Fun with Transactions - Part I

Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @nakulv_sql
Google Plus: +Nakul
Post #985201
Posted Monday, September 13, 2010 9:32 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:05 AM
Points: 20,458, Visits: 14,085
Nice question - thanks.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #985202
Posted Monday, September 13, 2010 10:41 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 2:13 AM
Points: 1,865, Visits: 368
learned something new today... thanks...
Post #985228
Posted Monday, September 13, 2010 11:55 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, January 02, 2014 9:57 AM
Points: 554, Visits: 863
Good Question thanks :)
Post #985249
Posted Tuesday, September 14, 2010 12:08 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 4:08 AM
Points: 1,849, Visits: 775
My guess is right.
Nice Question.


Regards,
Rals
.
Post #985254
Posted Tuesday, September 14, 2010 12:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 12,206, Visits: 9,168
Nice question about the transaction basics. As I'm reading the self-paced training kit for the database developper certification, this was a really easy one for me, as it is explained quite clearly in the book.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #985276
Posted Tuesday, September 14, 2010 1:14 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:17 PM
Points: 1,381, Visits: 1,774
da-zero (9/14/2010)
Nice question about the transaction basics. As I'm reading the self-paced training kit for the database developper certification, this was a really easy one for me, as it is explained quite clearly in the book.


It is really good to know that the question helped in your preparations. Best of luck for your exam!


Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @nakulv_sql
Google Plus: +Nakul
Post #985279
Posted Tuesday, September 14, 2010 1:46 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, December 05, 2013 7:19 AM
Points: 69, Visits: 65
Oops, I got it wrong.

In my defence, nesting works all over Microsoft so I'm a little surprised they never got it working here. Almost seems like an oversight.

Would have made more sense if they had employed a slightly different keyword such as e.g.

ROLLBACK TRAN ALL
or
ROLLBACK TRANSACTIONS

Just my view
Post #985299
Posted Tuesday, September 14, 2010 1:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 12,206, Visits: 9,168
phil.wood 94423 (9/14/2010)
Oops, I got it wrong.

In my defence, nesting works all over Microsoft so I'm a little surprised they never got it working here. Almost seems like an oversight.

Would have made more sense if they had employed a slightly different keyword such as e.g.

ROLLBACK TRAN ALL
or
ROLLBACK TRANSACTIONS

Just my view


Nesting does work with transactions. It's just that if you use rollback transaction, then all open transactions are rolled back. If you commit a transaction, then only the innermost transaction is committed.

If you really want full nesting, you can use checkpointing in your transactions and use named transactions.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #985304
Posted Tuesday, September 14, 2010 1:57 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, December 05, 2013 7:19 AM
Points: 69, Visits: 65
That'll teach me to shoot before I aim.

Thanks
Post #985308
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse