Reformat via query?

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

  • 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]

  • Haha, good start into a friday 🙂

    Best Regards,

    Chris Büttner

  • 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?

  • How did you put the message in red

    "Keep Trying"

  • 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

  • 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 😉

  • 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!)

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

  • going to prod server ssms window now..

  • 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.

  • 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

  • A really great chuckle to start off a Friday !

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

  • 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

  • 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