LMBOPS
asked on
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,
Harry
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,
Harry
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.