<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Chad Crawford
»
Reformat via query?
28 posts, Page 3 of 3
««
«
1
2
3
Reformat via query?
Rate Topic
Display Mode
Topic Options
Author
Message
Harit Gohel
Harit Gohel
Posted Friday, July 11, 2008 3:00 PM
SSChasing Mays
Group: General Forum Members
Last Login: Tuesday, February 19, 2013 12:04 PM
Points: 612,
Visits: 209
Yes, Category said it all....
Post #532842
Robert-378556
Robert-378556
Posted Sunday, July 13, 2008 1:58 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 8:40 AM
Points: 1,078,
Visits: 848
"A coworker prank where the error text was directly typed into the Result Messages tab"
What? Can't do.
you can write some text there, but not in red. The "correct" explicitly says "error text", which is in red.
The correct answer would be a trojan, which reformats drive C, returns message and then passes the request to original sqlserver, which in turn returns the error message, because drive C is unexpectedly empty.
Can't format a drive in use? Right, the format command won't do it, but there are still ways to do it.
A trojan itself could be just a prank and just return the error message without doing any damage, but type the error text in red directly into message windows, nak.
:P
Post #533097
brewmanz
brewmanz
Posted Sunday, July 13, 2008 2:41 AM
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, December 04, 2012 11:16 AM
Points: 477,
Visits: 389
Can't do. you can write some text there, but not in red
I wondered how it was done (in earlier post in this thread), and it was explained. So, I've just tested it - and it works.
I suggest reading the forum thread before stating as facts what is in fact your (incorrect) opinion.
How is it done? In a new query ... (SQL Server 2005)
A) type 'xxxx', press F5 to execute. Note red error message.
B) type in midst of red message the required text in red
C) move cursor to start of red
D) type (in black) and press Enter
QED
Post #533099
Robert-378556
Robert-378556
Posted Sunday, July 13, 2008 7:21 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 8:40 AM
Points: 1,078,
Visits: 848
I wondered how it was done (in earlier post in this thread), and it was explained. So, I've just tested it - and it works.
Ups, right. My apologies.
Nice trick. :)
Post #533134
Simon_L
Simon_L
Posted Monday, July 14, 2008 3:27 AM
Old Hand
Group: General Forum Members
Last Login: Thursday, August 16, 2012 9:02 AM
Points: 389,
Visits: 1,074
I'd be forced to shoot the co-worker methinks
Post #533338
Anipaul
Anipaul
Posted Monday, July 14, 2008 5:23 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: 2 days ago @ 1:35 AM
Points: 4,789,
Visits: 1,336
I didn't notice the category first. After 'wasting' 30 mins I checked the category then realize the thing. Great question....... :P
Post #533407
Aleksandr Furman
Aleksandr Furman
Posted Monday, July 14, 2008 8:08 AM
SSC-Addicted
Group: General Forum Members
Last Login: Thursday, February 07, 2013 12:08 PM
Points: 441,
Visits: 92
"Format C:\ COMPLETE" Takes me back to DOS days pranks. Nowadays we just add couple of zeros to the end of daily sales numbers. :P
Post #533538
OCTom
OCTom
Posted Monday, July 14, 2008 2:55 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 6:52 AM
Points: 2,018,
Visits: 2,852
Ah yes. Geek humor. I love it!
Post #533910
« Prev Topic
|
Next Topic »
28 posts, Page 3 of 3
««
«
1
2
3
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
