Post reply

Document the output of all the SPs in HTML fashion

  • September 8, 2015 at 6:42 pm

    #320292

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

  • September 24, 2015 at 6:37 am

    #1829101

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

  • September 24, 2015 at 7:36 am

    #1829142

    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 2 (of 2 total)

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