Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How to determine metadata on DBCC results RE: How to determine metadata on DBCC results

  • May 26, 2015 at 4:58 pm

    #1800720

    It used to be possible using a "LoopBack" linked server but the latest "improvements" in SQL Server 2012 put the kibosh on all that. Now, all you get is the following...

    Msg 11528, Level 16, State 1, Procedure sp_describe_first_result_set, Line 1

    The metadata could not be determined because statement 'DBCC LOGINFO();' in procedure 'loginfo' does not support metadata discovery.

    Don'cha just love progress? Now, duck! Here come all the folks that are going to yell about using undocumented stored procedures. 😀 The thing is, this undocumented procedure didn't change... their other "improvements" broke it. 😉

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