Wouldn't a search of dependencies tell you?
{edit} Bad suggestion on my part. :blush: Like Steve says below, it's NOT 100% guaranteed. It's always worked for me in the past but that's only because I (apparently) got lucky and followed "the rules". I knew that dynamic SQL wouldn't register but I didn't know the "fault" induced by deferred naming, etc.
See sys.sql_dependencies in Books Online for more info on why a dependency may or may not exist.
--Jeff Moden
Change is inevitable... Change for the better is not.