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 «««123

Reformat via query? Expand / Collapse
Author
Message
Posted Friday, July 11, 2008 3:00 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:40 PM
Points: 612, Visits: 212
Yes, Category said it all....
Post #532842
Posted Sunday, July 13, 2008 1:58 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 4:37 AM
Points: 1,275, Visits: 932
"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
Posted Sunday, July 13, 2008 2:41 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 3:37 AM
Points: 488, Visits: 405
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
Posted Sunday, July 13, 2008 7:21 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 4:37 AM
Points: 1,275, Visits: 932

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
Posted Monday, July 14, 2008 3:27 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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
Posted Monday, July 14, 2008 5:23 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,439, Visits: 1,400
I didn't notice the category first. After 'wasting' 30 mins I checked the category then realize the thing. Great question....... :P


Post #533407
Posted Monday, July 14, 2008 8:08 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:22 AM
Points: 453, Visits: 102
"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
Posted Monday, July 14, 2008 2:55 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 2,630, Visits: 4,036
Ah yes. Geek humor. I love it!

Post #533910
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse