SSMS Error Message

Question

SSMS Error Message

sknox

SSChampion

Points: 12388
More actions
May 25, 2013 at 11:38 am

#394847

Comments posted to this topic are about the item SSMS Error Message
May 27, 2013 at 2:13 am

This was removed by the editor as SPAM

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

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 More actions · Answer 2

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: 21700 More actions · Answer 3

M&M

SSC-Insane

Points: 21700

May 26, 2013 at 10:18 pm

#1618672

Got tricked 🙂

M&M

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 4

Good question. Great start of week 😀

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

zerko SSCommitted Points: 1524 More actions · Answer 5

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: 9063 More actions · Answer 6

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)

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 7

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: 22668 More actions · Answer 8

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: 9063 More actions · Answer 9

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 More actions · Answer 10

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: 2377 More actions · Answer 11

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: 104210 More actions · Answer 12

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: 104773 More actions · Answer 13

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