SQL Server Performance Forum – Threads Archive

Object Dependancy

Hello Friends, Do anyone has wrote a scripts to find objects dependancy.Actually i am trying to find using scripts whether table or stored procedure,trigger etc.. has what all dependancy in SQL 2000 database. If you have any idea or query do let me know. Thanks and Regards
Ravi Kumar

---

Try AGS SQL Scribe Documentation Builder. You can see details in Forum Tools.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.

---

Why not use sp_depends and thishttp://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=533 link for more joy. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

Hello Satya,
Based on your feedback i used sp_depends stored procedure to get the dependency but whta i have found that sp_depends output give dependent object name upto level 1. it does not display the object of level 2 onwards. Try this. Use northwind database and execute below query.
SP_DEPENDS ORDERS you will get 13 objects If you execute below query to get data from sysdepends table you will get. SELECT o.name,o.type FROM sysdepends d,sysobjects o
where d.id=o.id
and depid=object_id(N'[dbo].[Orders]’)
order by o.type,depnumber Thanks and Regards
Ravi Kumar

---

]]>