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 1234»»»

Transactions 3 Expand / Collapse
Author
Message
Posted Tuesday, May 29, 2012 8:23 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
Comments posted to this topic are about the item Transactions 3

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1308090
Posted Tuesday, May 29, 2012 10:33 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 4:43 AM
Points: 1,130, Visits: 1,391
Nice & easy question...

Thanks
Post #1308103
Posted Tuesday, May 29, 2012 10:50 PM


Default port

Default portDefault portDefault portDefault portDefault portDefault portDefault portDefault port

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 4:53 AM
Points: 1,433, Visits: 1,845
Nice & easy question. Brings back memories from a couple of days ago

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1308107
Posted Tuesday, May 29, 2012 10:51 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 16, 2014 2:12 PM
Points: 2,278, Visits: 3,798
Good one. Got this right this time

Mohammed Moinudheen
Post #1308108
Posted Tuesday, May 29, 2012 11:00 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 5:41 PM
Points: 471, Visits: 875
Is this not the same question that we've had three times now?

Maybe the addition of set XACT_ABORT OFF

But it's off by default, right?

I guess it reinforces how transactions work in MSSQL so it's a good thing.
Post #1308111
Posted Wednesday, May 30, 2012 1:56 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:37 AM
Points: 4,013, Visits: 5,306
Good back-to-basic question, thanks Ron

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1308144
Posted Wednesday, May 30, 2012 2:05 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:54 AM
Points: 1,779, Visits: 6,463
Presumably the 21% who answered "0" didn't read the discussions following the previous question :)
Post #1308147
Posted Wednesday, May 30, 2012 2:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 11:12 AM
Points: 7,791, Visits: 9,545
Until I saw the counts of answers so far I thought that maybe this repetition with tiny variations (this is the third version of this question in a couple of weeks) was a bit much, but then I saw that 29% (77 out of 270) so far have got this wrong, so now I reckon the repetition is useful after all.

Tom
Post #1308170
Posted Wednesday, May 30, 2012 4:10 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:14 AM
Points: 1,732, Visits: 1,142
Well, I think I'll remember this one now anyhow! I did have to check the ON / OFF status and which meant what, as Microsoft do not always seem to agree with my mental logic on binary switches and how they are named. They did this time!
Post #1308213
Posted Wednesday, May 30, 2012 5:09 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:33 AM
Points: 13,248, Visits: 11,025
Another great question Ron. It certainly useful to refreshen the transaction theory from time to time.



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 #1308249
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse