OK i'm looking for dependencies of an object I need to get out of my database becasue we are no longer using it (at least in theory, we'll see as I remove the dependencies). I found 10 dependencies using sp_depends, but considerably more in Enterprise manager using the look at dependencies icon inthe table design mode. Since this is the list I'd prefer to work with, I was wondering if anyone knows what system stored procedure gets this more complete list? Clearly sp_depends does not give me the complete list.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sp_depends
- Thread starter SQLSister
- Start date
- Status