My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Finding objects with a certain name
The new RSS feed is here
Jamie has talked about finding objects reference in SPs and a bit of SQL for this http://blogs.conchango.com/jamiethomson/archive/2005/08/17/2031.aspx. I find that I put these in an procedure prefixed sp and put in master I can then use the shortcut features in Query analyser and SQL Server management studio to execute the sp against some highlighted text.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Finding objects with a certain name