Document the output of all the SPs in HTML fashion

• e.dicesare

  Valued Member

  Points: 59

  More actions

  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

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  September 24, 2015 at 6:37 am

  #1829101

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

• BobbyD01

  SSC Enthusiast

  Points: 136

  More actions

  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!