SQL 2k "Where Used" utilities

[homebrew]

Does anyone know of utilities or tools that allow me to get info such as:

Where a stored procedure is referenced ... such as tell me everywhere StorProcB is used

Where Tables are used or referenced. Such as: What uses TableA
Answer: DTSPkg1, DTSPkg7, StorProcF

Back on the old AS/400 it was easy to buy or write my own utlities for this kind of info ... even down to the field level or character string .......... I'd really like something for SQL.

Any ideas ?

[MAK]

u can use object browser in Query analyser where there is a subfolder on any object called "Dependancies". That will give u that info.

If u like to search an object in a database press F4 or click object search.

I dont think u can search dependancies in DTS packages.