SSMS Error Message

Question

Post reply

SSMS Error Message

Viewing 15 posts - 16 through 30 (of 32 total)

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

malleswarareddy_m SSCertifiable Points: 5847 More actions · Answer 1

Easy question and more over its fun. I also had done this in many times.

Malleswarareddy
I.T.Analyst
MCITP(70-451)

seatedElephant Say Hey Kid Points: 674 More actions · Answer 2

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 :alien:

"Measure twice, saw once"

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

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

dhober Ten Centuries Points: 1084 More actions · Answer 4

Being that my name is Dave, I always wonder when I see messages like that

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 5

I'm pretty sure the first answer could be correct as well...

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Revenant SSC-Forever Points: 42467 More actions Follow · Answer 6

Revenant

SSC-Forever

Points: 42467

May 28, 2013 at 1:58 pm

#1619109

mohammed moinudheen (5/26/2013)
Got tricked

+1

jlennartz SSCommitted Points: 1574 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)

+1

Bangla Hall of Fame Points: 3137 More actions · Answer 8

Bangla

Hall of Fame

Points: 3137

May 28, 2013 at 11:19 pm

#1619174

Nice one...

ITGuy268 Mr or Mrs. 500 Points: 550 More actions · Answer 9

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

HongNine Grasshopper Points: 20 More actions · Answer 10

HongNine

Grasshopper

Points: 20

May 29, 2013 at 8:46 pm

#1619542

but can't type with red color.

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

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/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Julie Hall of Fame Points: 3292 More actions · Answer 12

I love learning something and having fun at the same time. Good question! :hehe:

SqlOnMyMind SSCertifiable Points: 5062 More actions · Answer 13

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!
:-D:-D

I am getting the impression that you have a lot more practical jokes up your sleeve!

angad.singh88 Old Hand Points: 300 More actions · Answer 14

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 !

sqlnaive SSCoach Points: 17437 More actions · Answer 15

I seriuosly looked out for a cath here and when couldn't found any, just gave up and selected the one which I could relate to. Later checked and found the fun part.

Having the question NOT IN (fun category) was fun.

SSMS Error Message

Cookies on SQLServerCentral