• Trying to figure out what you need and this seems simple to you because you know what you want... but we don't...

    You say the copy/paste into Excel is tedious... what is it about it that's tedious? Do you need to split the Status column or are you trying to paste the output exactly like it is or what?

    Are you using the grid mode for the copy paste or the text mode?

    Please help us help you... be a bit more descriptive as to what you'd like to get from sp_HelpDB into Excel.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)