May 27, 2013 at 8:52 am
Easy question and more over its fun. I also had done this in many times.
Malleswarareddy
I.T.Analyst
MCITP(70-451)
May 28, 2013 at 3:13 am
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"
May 28, 2013 at 5:34 am
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.
May 28, 2013 at 5:55 am
Being that my name is Dave, I always wonder when I see messages like that
May 28, 2013 at 9:33 am
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
May 28, 2013 at 1:58 pm
mohammed moinudheen (5/26/2013)
Got tricked
+1
May 28, 2013 at 3:52 pm
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
May 28, 2013 at 11:19 pm
Nice one...
May 29, 2013 at 4:01 am
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
May 29, 2013 at 8:46 pm
but can't type with red color.
May 30, 2013 at 12:37 am
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.
May 30, 2013 at 7:26 am
I love learning something and having fun at the same time. Good question! :hehe:
May 30, 2013 at 8:36 am
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!
May 31, 2013 at 2:19 am
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 !
June 5, 2013 at 1:34 am
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.
Viewing 15 posts - 16 through 30 (of 32 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy