SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reformat via query?


Reformat via query?

Author
Message
Harit Gohel
Harit Gohel
SSC Eights!
SSC Eights! (896 reputation)SSC Eights! (896 reputation)SSC Eights! (896 reputation)SSC Eights! (896 reputation)SSC Eights! (896 reputation)SSC Eights! (896 reputation)SSC Eights! (896 reputation)SSC Eights! (896 reputation)

Group: General Forum Members
Points: 896 Visits: 232
Yes, Category said it all....Hehe
Robert-378556
Robert-378556
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3615 Visits: 1015
"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.
Tongue
brewmanz
brewmanz
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1068 Visits: 406
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
Robert-378556
Robert-378556
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3615 Visits: 1015

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. Smile
Simon_L
Simon_L
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2357 Visits: 1075
I'd be forced to shoot the co-worker methinks



Anipaul
Anipaul
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14545 Visits: 1407
I didn't notice the category first. After 'wasting' 30 mins I checked the category then realize the thing. Great question....... Tongue



Aleksandr Furman
Aleksandr Furman
Right there with Babe
Right there with Babe (758 reputation)Right there with Babe (758 reputation)Right there with Babe (758 reputation)Right there with Babe (758 reputation)Right there with Babe (758 reputation)Right there with Babe (758 reputation)Right there with Babe (758 reputation)Right there with Babe (758 reputation)

Group: General Forum Members
Points: 758 Visits: 128
"Format C:\ COMPLETE" Takes me back to DOS days pranks. Nowadays we just add couple of zeros to the end of daily sales numbers. Tongue
OCTom
OCTom
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5965 Visits: 4152
Ah yes. Geek humor. I love it!

w00t
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search