having a "find all references" feature is a god send. can't tell you how many time i've scripted the database to a new query window and did a manual search just to find out all the place a stored procedure is being used.
http://www.red-gate.com/products/sql-development/sql-search/
It's of course possible to do this by looking through systables/information_schema/etc (I'm sure this is how you're doing it) but I always forget how. :)