sp_depends in SQL Server, what are possible dependencies?

sql-server stored-procedures views depends
Pritesh picture Pritesh · Aug 29, 2012 · Viewed 17.3k times · Source

I have used sp_depends first time like this 

sp_depends TestTable

As result I got some stored procedures and views. Now when I look (Ctrl F for TestTable) at script of stored procedures and views I do not see that they would be referring to TestTable.

If not using script is there any other dependency could be there? If yes how?

Answer

gbn picture gbn · Aug 29, 2012

sp_depends is prehistoric and unreliable.

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities instead.

Even better, consider using Red Gate's free SQL Search tool...

Related questions

Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? Select all data from BusinessLine into tmpBusLine works fine. select * into tmpBusLine from BusinessLine I am trying the same, but …

Read More
Search text in stored procedure in SQL Server

I want to search a text from all my database stored procedures. I use the below SQL: SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_…

Read More
SQL Server - SELECT FROM stored procedure

I have a stored procedure that returns rows: CREATE PROCEDURE MyProc AS BEGIN SELECT * FROM MyTable END My actual procedure is a little more complicated, which is why a sproc is necessary. Is it possible to select the output by …

Read More