Results 1 to 3 of 3

Thread: Tables used by SP

  1. 12-30-2002, 01:34 PM #1
    CEE
    CEE is offline Registered User
    Join Date
    Dec 2002
    Location
    Solano County
    Posts
    2

    Tables used by SP

    Anyone know of a way to determine what tables are accessed by my stored procedures without me opening up each one individually?
    Reply With Quote Reply With Quote
  2. 12-30-2002, 01:40 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can use sp_depends stored procedure.
    Reply With Quote Reply With Quote
  3. 12-30-2002, 02:05 PM #3
    CEE
    CEE is offline Registered User
    Join Date
    Dec 2002
    Location
    Solano County
    Posts
    2
    Thank you. This will work for one procedure at a time. Do you know of any scripts that accomplishes this task for more than one procedure at a time?

    Thanks again for your help:-)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules