Post reply

Any Way to Programmatically Document Stored Procedures?

  • May 3, 2010 at 9:54 am

    #140689

    I would like to document parameters, tables, functions called, etc for our stored procedures. We already have a query that returns the parameters for each.

    Does anyone know of an efficient way to get tables used, functions called etc. for stored procedures?

    Thanks!

    Liz

  • May 3, 2010 at 10:21 am

    #1161379

    Have you taken a look at the dependencies? There's a system view called sys.sysdepends which should have a LOt of that data.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • May 3, 2010 at 12:02 pm

    #1161423

    I will check that out. Thanks.

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

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