Anyone know of a way to determine what tables are accessed by my stored procedures without me opening up each one individually?
Printable View
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:-)