Post reply

Reformat via query?

  • July 10, 2008 at 8:33 pm

    #190364

    Comments posted to this topic are about the item Reformat via query?

  • July 10, 2008 at 9:47 pm

    #841223

    I always wonder why the Message window is NOT read-only. The negative impact is clearly mentioned in the Answer of this question. Why not it is read-only...?

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

  • July 11, 2008 at 1:04 am

    #841274

    Haha, good start into a friday 🙂

    Best Regards,

    Chris Büttner

  • July 11, 2008 at 2:18 am

    #841300

    I would have chosen the correct answer, except I can't think of how to type text to show in red the Messages tab. Can someone help me out with that?

  • July 11, 2008 at 2:31 am

    #841302

    How did you put the message in red

    "Keep Trying"

  • July 11, 2008 at 2:36 am

    #841306

    I assume you can run any statement after you have "temporarily disabled access" to the file.

    Then add the black text into the results tab.

    But just a thought. (If that is possible at all)

    Best Regards,

    Chris Büttner

  • July 11, 2008 at 4:14 am

    #841336

    It is possible to replicate the results,

    Open up a query window to a database and type in "SELECT * FROM sys.master_files", then open "activity monitor" and kill the SPID which corresponds to the Query window.

    Now execute the query, and you'll get the red Transport-Level error. Move cursor into the Message window and add the "Formatting" error in black, and hey presto, Prankus Maximus.

    Like it 🙂 Must remember this one.. hehe.

    P.S. Putting the question in the category 'Humour' kinda gives it away though 😉

  • July 11, 2008 at 5:22 am

    #841360

    Thanks for the explanation, Nick!

    I picked another answer after deciding I could neither fake a message tab nor the red font color.

    (Remind me not to be interviewed by you!)

  • July 11, 2008 at 5:58 am

    #841385

    The category of the question 'humor' gave the answer away. You should have left it un categorized.

  • July 11, 2008 at 7:01 am

    #841443

    going to prod server ssms window now..

  • July 11, 2008 at 7:16 am

    #841460

    Getting the red error message is easy. Just type SELECT and execute. A red error message will appear which can then be changed to whatever you want and it will still be in red. The go to the beginning of the text and add a blank line. Anything typed on the blank line will be in black.

  • July 11, 2008 at 8:01 am

    #841502

    This is a great question to keep people from cheating by running it. 🙂

    Cheers,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • July 11, 2008 at 8:33 am

    #841546

    A really great chuckle to start off a Friday !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • July 11, 2008 at 8:41 am

    #841555

    Possibly trite but finding the sense of humor on these questions can be as adverse as some of the toughest questions. I comment when right and for obvious reasons, I do not comment frequently on humor.

    Jamie

  • July 11, 2008 at 8:52 am

    #841567

    SELECT Location

    FROM Emotions

    WHERE Emotion = 'Sense Of Humour'

    AND Owner = 'Your'

    😉

    *Ducks the incoming abuse*

Viewing 15 posts - 1 through 15 (of 27 total)

You must be logged in to reply to this topic. Login to reply