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: Saturday, December 20, 2014 3:11 PM
Points: 31,368, Visits: 15,837
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:32 PM
Points: 18,068, Visits: 16,111
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: 2 days ago @ 4:17 AM
Points: 1,963, Visits: 2,407
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: Monday, December 1, 2014 4:08 AM
Points: 987, Visits: 567
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 19, 2014 10:18 AM
Points: 1,058, Visits: 2,359
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: Today @ 2:34 PM
Points: 1,930, Visits: 2,208
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 @ 7:18 PM
Points: 7,930, Visits: 9,654
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: Yesterday @ 11:31 AM
Points: 3,422, Visits: 2,038
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: Thursday, December 18, 2014 2:24 PM
Points: 1,893, Visits: 1,352
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