Advertisement

05.20.2004 at 12:28PM PDT, ID: 20996679
[x]
Attachment Details

Table Dependencies

Asked by LMBOPS in MS SQL Server

Tags: table, dependencies

i have couple of dependencies on a table.

I used sp_depends to identify the dependencies on this specific table which lets me know that there is a stored procedure. But to my experience i know that there is some other process that uses the same table i don't know any other way to identify this.

Basically what i need is to find which objects are using a specific table in entire database when we pass table as parameter, even in dts packages, jobs etc.

Thanks,

HarryStart Free Trial
[+][-]05.20.2004 at 01:57PM PDT, ID: 11121630

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: table, dependencies
Sign Up Now!
Solution Provided By: arbert
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32