• Two critical questions:

    1.) Exactly what do you mean when you say "print"? That can mean anything from getting text output for copy and paste elsewhere, to actually printing something on a printer.

    2.) Exactly what formatting are you seeking to preserve? If you're referring to the color of the keywords, be aware that with SQL Server 2005 and later, SSMS does exactly that if you merely copy and paste the text from a query window into a rich-text capable editor, such as WordPad or MS Word. I've found that using Landscape orientation is usually best when the ultimate desired result is a printed output from a color capable printer.

    Steve

    (aka smunson)

    :):):)

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)