dcsimg
Results 1 to 2 of 2

Thread: Table - stored procedure dependency script in sql 2005

  1. #1
    Join Date
    Nov 2010
    Posts
    2

    Table - stored procedure dependency script in sql 2005

    Hello,

    I tried to document all of our database object dependencies. There are about 230+ stored procedures and we are looking for down stream (tables that the sp depend on) and upstream table (table that sp generate - or output table.) There is manual way of doing this by right click on the sp, then select View Dependencies for each sp. That's very time consumming. Is there any system script that available for this purpose? Thanks for your help.

    Sunny

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Take look at sp_depends in books online.

Posting Permissions

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