Viewing 2 posts - 1 through 2 (of 2 total)
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)...
October 30, 2013 at 4:08 am
#1662648
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...
April 12, 2010 at 4:38 am
#1149904