Post reply

SQL Server Error Handling

  • March 30, 2013 at 11:15 am

    #74470

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

  • March 31, 2013 at 9:26 am

    #1602322

    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

  • March 31, 2013 at 11:12 pm

    #1602376

    Easy question 😀 and lots of points.:w00t:

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

  • April 1, 2013 at 12:07 am

    #1602381

    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/

  • April 1, 2013 at 1:07 am

    #1602385

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

  • April 1, 2013 at 3:32 am

    #1602400

    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.

  • April 1, 2013 at 5:02 am

    #1602413

    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

  • April 1, 2013 at 5:54 am

    #1602421

    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

  • April 1, 2013 at 8:22 am

    #1602465

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

  • April 1, 2013 at 8:32 am

    #1602469

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

  • April 1, 2013 at 9:28 am

    #1602497

    🙂

    Thanks. Steve!

  • April 1, 2013 at 9:29 am

    #1602498

    I found this option in SQL 2020 SP4

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

  • April 1, 2013 at 9:32 am

    #1602500

    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

  • April 1, 2013 at 11:51 am

    #1602550

    awesome..

    I got 7 points..

  • April 1, 2013 at 1:36 pm

    #1602580

    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

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

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