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
Start Free Trial