var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to check which tables were called?
I have some nightly jobs that execute stored procedure to call the tables? I want to know which table are called by these stored procedures. Is it possible? Any idea will be appreciated.
Lemme get this right, you have a series of stored procedures that run every night, but want a list of the affected tables? basically a listing of the tables in those stored procedures run at night?
Basically, in stead of reading through the SP's and noting the tables used, you want an automation process?
Yes, I need a table list that are affected in the nightly job/
Just do sp_depends on all of the stored procedures
CREATE PROC mySproc99
SELECT * FROM Orders
EXEC sp_depends mySproc99
DROP PROC mySproc99
...although be aware that this will not show tables referenced in dynamic SQL statements embedded in your procedures.
True..and if the tables was dropped and recreated it won't show as well..
How about adding some triggers