Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Monday, May 23, 2016 6:13 AM
Points: 15,149, Visits: 13,035
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 SQLKover.

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:34 PM
Points: 5,110, Visits: 4,225
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: Tuesday, March 17, 2015 12:29 PM
Points: 794, Visits: 1,197
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
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Monday, May 16, 2016 11:53 PM
Points: 1,456, Visits: 180
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: Thursday, December 3, 2015 10:55 AM
Points: 120, Visits: 263
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: Friday, July 10, 2015 1:51 AM
Points: 4, Visits: 29
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 @ 2:28 PM
Points: 7,621, Visits: 10,488
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: Tuesday, February 2, 2016 1:45 PM
Points: 1,379, Visits: 857
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: Monday, December 28, 2015 12:16 PM
Points: 1,676, Visits: 1,948
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