Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2009-04-25 : 06:17:45
|
| I need to find the dependency of my given object . ex: if my object is table mean , dependendent object may be , SP,VIEW,FUNCTION ....If is give SP , it should display all dependent SP , tables , view ...can i use sp_depends ?? or anything advance is here ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-25 : 06:22:00
|
Yes. There are system views to accomplish this too.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2009-04-25 : 06:32:03
|
| it returns only current database .. same table may exist in different database.. can i bring that in any other way |
|
|
|
|
|
|
Dependency object