SQL Server Error Handling

Question

SQL Server Error Handling

Steve Jones - SSC Editor

SSC Guru

Points: 738237
More actions
March 30, 2013 at 11:15 am

#74470

Comments posted to this topic are about the item SQL Server Error Handling

Viewing 15 posts - 1 through 15 (of 31 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281344 More actions · Answer 1

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[/url]
Learn Extended Events

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 2

Easy question and lots of points.:w00t:

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

kapil_kk SSC-Insane Points: 21316 More actions · Answer 3

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/

Dineshbabu Hall of Fame Points: 3220 More actions · Answer 4

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 5

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.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 6

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.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Amusing question :-P.

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 :w00t: for this question.

Tom

Ken SSCoach Points: 17191 More actions · Answer 8

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.

Primo Dang SSCrazy Points: 2643 More actions · Answer 9

Yet another humor question that went right over my head. I really should stop answering these before coffee... there go seven whole points! :crying:

Revenant SSC-Forever Points: 42467 More actions · Answer 10

Revenant

SSC-Forever

Points: 42467

April 1, 2013 at 9:28 am

#1602497

Thanks. Steve!

chgn01 SSCarpal Tunnel Points: 4408 More actions · Answer 11

I found this option in SQL 2020 SP4

--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius

SQLRNNR SSC Guru Points: 281344 More actions · Answer 12

chgn01 (4/1/2013)
I found this option in SQL 2020 SP4

Sweet

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 13

PChiragS

SSCarpal Tunnel

Points: 4965

April 1, 2013 at 11:51 am

#1602550

awesome..

I got 7 points..

TomThomson SSC Guru Points: 104773 More actions · Answer 14

KWymore (4/1/2013)
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.

Actually I think I misread the question (actually I diodn't bother to look at what the command was supposed to mean, and interpreted it as meaning something else - that kind of mistake is even siller than misreading - but it made no real difference.

Tom

SQL Server Error Handling

Cookies on SQLServerCentral