Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Question Unanswered: Documenting existing stored procedures

    Does anyone have any scripts, or know of any tools, that can scan through all of the SPs that I have inherited, documenting details?

    Thx

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    This will retrieve the name and text of all the stored procedures.
    Code:
    SELECT a.name, b.text 
    FROM sysobjects a INNER JOIN syscomments b ON
      a.id = b.id
    WHERE
      a.xtype = 'P'
    This will retrieve the input parameters for all stored procedures in a database:
    Code:
    SELECT a.name, b.* 
    FROM sysobjects a INNER JOIN syscolumns b ON
    	a.id = b.id
    WHERE
    	a.xtype = 'P'
    What else are you looking to do?
    Have you hugged your backup today?

  3. #3
    Join Date
    Sep 2004
    Posts
    2
    thanks!

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Did you use Enterprise Manager to script out the stored procedures and the like?

    You can use this to Search your database

    Good Luck
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •