-
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?
-
You can use sp_depends stored procedure.
-
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:-)
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
|
|