Document the output of all the SPs in HTML fashion

  • e.dicesare

    Valued Member

    Points: 59

    Comments posted to this topic are about the item Document the output of all the SPs in HTML fashion

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    The article sounds interesting. I'll have to try the script out. Thanks.

  • BobbyD01

    SSC Enthusiast

    Points: 136

    Very interesting article. May I suggest trapping the error that comes back from sys.dm_exec_describe_first_result_set_for_object in the event there is an error. In my testing, all of the procedures I had returned no results in your procedure, other than the name. However, when querying dm_exec_describe_first_result_set_for_object independently, I see an error and it appears it is because I'm using temp tables in my procedure.

    Here's an example of the error_message column's value:

    "The metadata could not be determined because statement 'INSERT INTO #tblMassInsert (StartTime, EndTime, Number1, Number2)

    VALUES(@StartTime, NULL, @Cu' in procedure 'spMASSInsert_DNB' uses a temp table."

    Hope that helps. Great work so far!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply