You can use this query to find all the tables used in a stored procedure.

;WITH stored_procedures AS (

SELECT

o.name AS proc_name, oo.name AS table_name,

ROW_NUMBER() OVER(partition by o.name,oo.name ORDER BY o.name,oo.name)...

So it will execute this forever? But obviously it won't execute forever, correct? Is there a time limit within SQL Server after which long running queries will be killed? How...