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 Tuesday, May 28, 2013 9:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 13,295, Visits: 11,086
I'm pretty sure the first answer could be correct as well...



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1457404
Posted Tuesday, May 28, 2013 1:58 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 12:43 PM
Points: 4,126, Visits: 3,428
mohammed moinudheen (5/26/2013)
Got tricked

+1
Post #1457505
Posted Tuesday, May 28, 2013 3:52 PM
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: Monday, September 22, 2014 3:13 PM
Points: 774, Visits: 1,179
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)


+1
Post #1457533
Posted Tuesday, May 28, 2013 11:19 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, October 20, 2014 3:10 AM
Points: 856, Visits: 163
Nice one...
Post #1457581
Posted Wednesday, May 29, 2013 4:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, October 11, 2014 7:06 AM
Points: 116, Visits: 249
A bit late I nearly picked option 3 'sp_addmessage' luckily realising it must have an ID between 50,001 and 2,147,483,647

Option 4 & +1 it is...


MCTS | MCITP | Microsoft SQL Server 2008 Administration & Development
MCSA | MCSE | Business Intelligence SQL Server 2012
Post #1457643
Posted Wednesday, May 29, 2013 8:46 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 14, 2013 7:00 PM
Points: 4, Visits: 22
but can't type with red color.
Post #1458019
Posted Thursday, May 30, 2013 12:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 6,048, Visits: 8,328
catus0124 (5/29/2013)
but can't type with red color.


You can't create red color in an empty message pane. But if you first execute a statement that will generate an error, then type new text in the middle of the red error message and delete the old error text, your typed text will be in red.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1458056
Posted Thursday, May 30, 2013 7:26 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 2:48 PM
Points: 1,379, Visits: 834
I love learning something and having fun at the same time. Good question!
Post #1458217
Posted Thursday, May 30, 2013 8:36 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:31 AM
Points: 1,579, Visits: 1,858
Loved the fun question! Thanks!

Carlo:
Carlo Romagnano (5/27/2013)
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 a neverending compile, instead it was ready!


I am getting the impression that you have a lot more practical jokes up your sleeve! ;)
Post #1458257
Posted Friday, May 31, 2013 2:19 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 6, 2013 4:34 AM
Points: 136, Visits: 79
Did not got it correct... Thank god no one played this prank with me... :)

--Angad Singh
If I Stop Learning, I Cease to Be A SIKH !
Post #1458558
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse