Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

SSMS Error Message Expand / Collapse
Author
Message
Posted Monday, May 27, 2013 2:56 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 3:40 AM
Points: 3,359, Visits: 1,330
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
Post #1457012
Posted Monday, May 27, 2013 3:44 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, December 14, 2014 11:09 PM
Points: 1,962, Visits: 2,406
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/
Post #1457023
Posted Monday, May 27, 2013 4:36 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 4:31 AM
Points: 278, Visits: 242
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...


Manik
You cannot get to the top by sitting on your bottom.
Post #1457047
Posted Monday, May 27, 2013 4:39 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:22 AM
Points: 5,888, Visits: 13,061
I too was hoping this was a humour question worth lots of easy points..............

especially as its a bank holiday here.


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

Post #1457048
Posted Monday, May 27, 2013 7:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:50 PM
Points: 7,923, Visits: 9,649
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
Post #1457098
Posted Monday, May 27, 2013 7:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:50 PM
Points: 7,923, Visits: 9,649
zerko (5/27/2013)
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! "

We do do that, don't we?

Well, yes, but

Do we always remember to have a secure BIOS password? Or even have a BIOS password at all?
Do we remember to leave the computer setup so that it will only boot from the main hard drive, not from a pen-drive, DVD, CD, or any other replaceable media?
If any of those 3 gets the answer "no" then this stunt is rather easy.

Besides, locking the computer when you leave is not very effective if half (or more) of your colleagues know your password, or it's one of the top 20 preferred passwords for your gender, or it's scribbled on a post-it note stuck to the underside of your mouse-mat because your employer's lunatic security policy requires passwords to have at least 12 characters each and at most 16 and pass a "strength" test and forces you to change them every 15 days with your last 293 passwords remembered by the system and not reusable. Those sorts of insecurities with passwords used to be extremely common, but I think it's got slightly better and they now are only rather common (although that might just be undue optimism on the part of people who tell me what it's like in their organisations now).


Tom
Post #1457108
Posted Monday, May 27, 2013 8:52 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 11:09 PM
Points: 1,940, Visits: 1,173
Easy question and more over its fun. I also had done this in many times.

Malleswarareddy
I.T.Analyst
MCITP(70-451)
Post #1457117
Posted Tuesday, May 28, 2013 3:13 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 4:36 AM
Points: 89, Visits: 344
Nice question and quite comical. Fluked it really as I didn't note the bit in BOL "between 50,001 and 2,147,483,647" for the @msgnum. Thanks.

Dave Morris

"Measure twice, saw once"
Post #1457236
Posted Tuesday, May 28, 2013 5:34 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 5:19 AM
Points: 4,605, Visits: 4,059
Perhaps I put too much thought into this, since I figured that we all actually do lock our computers when we're not using them. I missed it, but also learned that you can type into the messages pane, which I've never done. Good trick question.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1457268
Posted Tuesday, May 28, 2013 5:55 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 8:12 AM
Points: 648, Visits: 252
Being that my name is Dave, I always wonder when I see messages like that :)
Post #1457273
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse