SSMS Error Message

  • sknox

    SSChampion

    Points: 12243

    Comments posted to this topic are about the item SSMS Error Message

  • SQLRNNR

    SSC Guru

    Points: 281205

    Easy enough - I have done this in the past.

    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

  • Iggy-SQL

    SSCarpal Tunnel

    Points: 4169

    Hah, didn't really read the sp_addmessage BOL, selected that one thinking it would have been added and someone ran a RAISERROR. I never knew you can actuall type on the SSMS' message window. I wonder what would be the purpose of allowing user to type into the message window?


    Urbis, an urban transformation company

  • M&M

    SSC-Insane

    Points: 21679

    Got tricked 🙂

    M&M

  • Danny Ocean

    SSCertifiable

    Points: 6098

    Good question. Great start of week 😀

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

  • zerko

    SSCommitted

    Points: 1524

    But surely, since ALL of us ALWAYS screen-lock our computers when we are not physically present, and the error message required someone else to type it into the SSMS Messages screen, the correct answer would have to be "That could not possibly happen! :w00t:"

    We do do that, don't we?

  • Mighty

    SSCrazy Eights

    Points: 8485

    Nice start of the week.

    One remark though:

    ...if you run code that generates an actual error

    This not only works when an error has been generated. Any message that is returned will enable it like the famous

    (1 row(s) affected)

  • This was removed by the editor as SPAM

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    Mighty (5/27/2013)


    Nice start of the week.

    One remark though:

    ...if you run code that generates an actual error

    This not only works when an error has been generated. Any message that is returned will enable it like the famous

    (1 row(s) affected)

    True, but since there is no way to manually apply formatting in the messages pane (as far as I know), the replacement text you type would still be in black.

    If you want the text in red, you need to ensure that SQL Server first puts a text in red there, then edit it. Depending on how you edit it, you can still lose the red color, or you can retain it.

    Nice question! I was surprised that it's not in the "fun" category, nor worth seven points - that was what I expected when I saw the question.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Carlo Romagnano

    SSC-Insane

    Points: 21833

    SQLRNNR (5/26/2013)


    Easy enough - I have done this in the past.

    +1

    In 80's, on mainfraim I placed the prompt with:

    "ADVANCED COBOL '85. COMPILING SOURCE ... SGCONT.CBL"

    So, it seemed an everending compile, instead it was ready!

    :-D:-D

  • Mighty

    SSCrazy Eights

    Points: 8485

    Hugo Kornelis (5/27/2013)


    True, but since there is no way to manually apply formatting in the messages pane (as far as I know), the replacement text you type would still be in black.

    If you want the text in red, you need to ensure that SQL Server first puts a text in red there, then edit it. Depending on how you edit it, you can still lose the red color, or you can retain it.

    I could argue that in the email the text of the QOTD in black was... 😀

    ...but I will not of course.

    Nice question! I was surprised that it's not in the "fun" category, nor worth seven points - that was what I expected when I saw the question.

    +1

  • kapil_kk

    SSC-Insane

    Points: 21316

    Hugo Kornelis (5/27/2013)


    Mighty (5/27/2013)


    Nice start of the week.

    One remark though:

    ...if you run code that generates an actual error

    This not only works when an error has been generated. Any message that is returned will enable it like the famous

    (1 row(s) affected)

    True, but since there is no way to manually apply formatting in the messages pane (as far as I know), the replacement text you type would still be in black.

    If you want the text in red, you need to ensure that SQL Server first puts a text in red there, then edit it. Depending on how you edit it, you can still lose the red color, or you can retain it.

    Nice question! I was surprised that it's not in the "fun" category, nor worth seven points - that was what I expected when I saw the question.

    True,

    I was aware about this fun thing so when I tried it text color was in black only...

    Sometime I able to retain the Red color and sometimes lose that....

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • manik_anu

    SSCrazy

    Points: 2367

    Mighty (5/27/2013)


    Nice start of the week.

    One remark though:

    ...if you run code that generates an actual error

    This not only works when an error has been generated. Any message that is returned will enable it like the famous

    (1 row(s) affected)

    ha... nice question... :w00t:

    Manik
    You cannot get to the top by sitting on your bottom.

  • george sibbald

    SSC Guru

    Points: 104200

    I too was hoping this was a humour question worth lots of easy points..............

    especially as its a bank holiday here.

    ---------------------------------------------------------------------

  • TomThomson

    SSC Guru

    Points: 104772

    Hugo Kornelis (5/27/2013)[hr.Nice question! I was surprised that it's not in the "fun" category, nor worth seven points - that was what I expected when I saw the question.

    Yes, very nice. Actually more fun that many of the fun questions that crop up regularly on certain days, and far more deserving of counting 7 points.

    Tom

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

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