I've always struggled with this. Red Gate's Dependency Tracker (grown out of a conversation that Andy and I had with Red Gate) really helps if you depend on these things.

I think one of the reasons I can be a control freak as a DBA is to ensure that I know, or can find out, what all objects are for.