SSMS Error Message

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

  • 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

  • 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

  • Got tricked 🙂

    M&M

  • Good question. Great start of week 😀

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

  • 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?

  • 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

  • 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/

  • 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

  • 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

  • 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/

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

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

    especially as its a bank holiday here.

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

  • 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 32 total)

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