Navigation

	Home Page
	Index
	All Pages

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

Tables Used by Stored Procedures - SQL Server

select distinct
     StoredProcedureName = a.name
    ,TableName           = b.name

from 
    sys.objects a

    inner join sys.sql_dependencies d
        on a.object_id = d.object_id

    inner join sys.objects b
        on b.object_id = d.referenced_major_id