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
Right there with Babe
Right there with Babe (714 reputation)Right there with Babe (714 reputation)Right there with Babe (714 reputation)Right there with Babe (714 reputation)Right there with Babe (714 reputation)Right there with Babe (714 reputation)Right there with Babe (714 reputation)Right there with Babe (714 reputation)

Group: General Forum Members
Points: 714 Visits: 232
Yes, Category said it all....Hehe
Robert-378556
Robert-378556
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2316 Visits: 1010
"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
Right there with Babe
Right there with Babe (757 reputation)Right there with Babe (757 reputation)Right there with Babe (757 reputation)Right there with Babe (757 reputation)Right there with Babe (757 reputation)Right there with Babe (757 reputation)Right there with Babe (757 reputation)Right there with Babe (757 reputation)

Group: General Forum Members
Points: 757 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
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2316 Visits: 1010

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
SSC Eights!
SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)

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



Anipaul
Anipaul
SSCrazy Eights
SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)

Group: General Forum Members
Points: 9611 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
Mr or Mrs. 500
Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)

Group: General Forum Members
Points: 561 Visits: 125
"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
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4065 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