sp_depends – Dependencies for Objects

Getting the list of tables and Columns that are embedded in a view ,function or a procedure is simple

sp_depends ‘viewName or ProcedureName‘

Documented in MSDN

http://msdn.microsoft.com/en-us/library/ms189487.aspx

Posted April 6, 2009 by Vivek. Comments and trackbacks are open. Follow the comments feed.
Filed under:
Tagged with: .

One Response to “sp_depends – Dependencies for Objects”

  1. Checking TSQL in SQL Server Reporting Services Datasets | Sqlserver007 says:
    October 13, 2009 at 12:31 pm

    [...] TableA to the new table TableB. Some of Datasets in the Reports are Stored Procedures and so I used sp_depends procedure to get the list of dependencies for [...]

    Reply

Leave a Reply

←
→