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 Saturday, May 25, 2013 11:38 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:26 AM
Points: 1,293, Visits: 1,646
Comments posted to this topic are about the item SSMS Error Message
Post #1456802
Posted Sunday, May 26, 2013 8:06 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 6:55 PM
Points: 21,204, Visits: 14,889
Easy enough - I have done this in the past.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1456943
Posted Sunday, May 26, 2013 9:28 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 9:26 PM
Points: 2,953, Visits: 436
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
Post #1456957
Posted Sunday, May 26, 2013 10:18 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:57 PM
Points: 2,270, Visits: 3,779
Got tricked

Mohammed Moinudheen
Post #1456962
Posted Sunday, May 26, 2013 11:29 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Good question. Great start of week



Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1456967
Posted Monday, May 27, 2013 12:37 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 10:53 PM
Points: 780, Visits: 640
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?
Post #1456979
Posted Monday, May 27, 2013 1:39 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 @ 10:08 AM
Points: 3,193, Visits: 1,232
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)
Post #1456996
Posted Monday, May 27, 2013 2:13 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: Today @ 10:54 AM
Points: 3,853, Visits: 4,991
Good question - highlights the importance of locking your machine before leaving your desk, even for a few seconds....

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1457000
Posted Monday, May 27, 2013 2:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:40 AM
Points: 5,916, Visits: 8,166
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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1457001
Posted Monday, May 27, 2013 2:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:24 AM
Points: 2,451, Visits: 2,342
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!

Post #1457003
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse