• That is all pretty good stuff, and most, I didn't know.

    I still use SQL Query Analyzer as my primary editing tool, and will continue to do so. I have even installed it to servers that have never seen SQL Server 2000. It's main limitation is it's inability to "Edit" (from the menu) an existing object, and that's not a real show stopper.

    The functionality of the SSMS SQL editor has gone the wrong way in my opinion.

    Annoyance #1: Double-click on a quoted or bracketed word, and the selection includes the quotes or brackets.

    Annoyance #2: Ctrl-Left, Ctrl-Right movements don't jump a block of special characters (--), but hops them one by one.

    If this is the "Old dog /New trick' thing, then so be it, but it's a great editor, and 'Start>>Run>>isqlw' is pretty firmly embedded in my memory. (:

    Tom Garth

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers