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

Question of the Day for 20 Jun 2007 Expand / Collapse
Author
Message
Posted Friday, June 1, 2007 12:05 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the Question of the Day for 20 Jun 2007 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=1062.
Post #370764
Posted Wednesday, June 20, 2007 12:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:21 AM
Points: 6,098, Visits: 8,367

Hi,

The explanation of this question says:

"This statement works like the ROLLBACK TRANSACTION statement, but it rolls back to the outer transaction and resets @@trancount to 0"

Whereas it should say:

"This statement works like the ROLLBACK TRANSACTION statement, and as such it rolls back to the outer transaction and resets @@trancount to 0"

ROLLBACK WORK is exactly the same as ROLLBACK TRAN




Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #375164
Posted Wednesday, June 20, 2007 3:03 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 4:53 AM
Points: 1,211, Visits: 79
In fact it only rolls back all work in open transactions for the current CONNECTION. A user can have multiple connections with open transactions and other connections for the same user are not affected


Post #375193
Posted Wednesday, June 20, 2007 3:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:21 AM
Points: 6,098, Visits: 8,367
Good point, Kelvin!


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #375195
Posted Thursday, January 2, 2014 1:56 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:42 PM
Points: 3,388, Visits: 2,021
I opted to look this one up and was glad that I did so. I wanted to say that Rollback Work was nonsense. I am surprised that the [Work] optional keyword has not been deprecated since it has no purpose. Has anyone seen the WORK keyword used in this context in production?
Post #1527277
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse