Detect Object dependencies.

By aikhooi, 2004/07/30

This stored procedure will detect all first level object dependencies on Stored Procedure.The result set will be stored in table Depend. Unlike sp_depends, sp_MSdependencies will be able to detect all links and dependencies associated to an object. It includes TRIGGER, DELETE, UPDATE etc .

Total article views: 262 | Views in the last 30 days: 4

FORUM

dependencies between stored procedures

Is there a way to identify the dependencies between stored procedures

SCRIPT

Dependencies View 2008

Provides a list of dependencies for a stored procedure

BLOG

Find Dependencies

Here's a script from my toolbox I use to find dependencies between SQL objects. The where clause ha...

ARTICLE

Data Profiling Column Functional Dependency T-SQL

This article demonstrates Data Profiling Functional Dependency

SCRIPT

When sp_depends fails

sp_depends may not always return accurate information

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com