Hi AD,
what about sp_depends <objectname>, though it does not work on indexes.
See also BOL for sp_depends!
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]