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

SQL Server Error Handling Expand / Collapse
Author
Message
Posted Saturday, March 30, 2013 11:15 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 3:49 PM
Points: 31,161, Visits: 15,607
Comments posted to this topic are about the item SQL Server Error Handling






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1437210
Posted Sunday, March 31, 2013 9:26 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:06 PM
Points: 17,805, Visits: 15,716
Interesting, I can use that set option in SP1 of SQL 2012.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1437292
Posted Sunday, March 31, 2013 11:12 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Easy question and lots of points.



Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1437355
Posted Monday, April 1, 2013 12:07 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:54 AM
Points: 1,921, Visits: 2,345
Ahhhhh........ I lost the chance to grab a lot of points



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1437360
Posted Monday, April 1, 2013 1:07 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, October 16, 2014 7:54 AM
Points: 959, Visits: 561
I dindn't get any results on googling. So i guessed there won't be any such set options introduced yet in MS SQL Server.

Thanks for easy points..


--
Dineshbabu
Desire to learn new things..
Post #1437365
Posted Monday, April 1, 2013 3:32 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 3:42 AM
Points: 998, Visits: 2,275
Awesome. Thank you for question and the points.



ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1437383
Posted Monday, April 1, 2013 5:02 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 10:42 AM
Points: 1,849, Visits: 2,185
SQLRNNR (3/31/2013)
Interesting, I can use that set option in SP1 of SQL 2012.


Not having yet moved to SQL 2012, I had to wrote my own sp to do this. The new feature will be a real time saver.


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1437397
Posted Monday, April 1, 2013 5:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:12 AM
Points: 7,791, Visits: 9,545
Amusing question .

Timeouts can cause rollback, but rollback pays no attention to them if they happen while it is executing - it just ignores it - because the whole concept of rolling back a rollback is just plain silly.

I thought everybody knew that until I saw 40% wrong answers for this question.


Tom
Post #1437407
Posted Monday, April 1, 2013 8:22 AM


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: Tuesday, October 14, 2014 9:44 AM
Points: 3,350, Visits: 2,000
I knew this had to be a trick question because I couldn't see why MS would add that command. As Tom said, rolling back a rollback is nonsense. Being April Fool's Day helped with my answer decision too.
Post #1437457
Posted Monday, April 1, 2013 8:32 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 5:54 PM
Points: 1,825, Visits: 1,284
Yet another humor question that went right over my head. I really should stop answering these before coffee... there go seven whole points!
Post #1437461
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse