Maybe already widely used but I thought this was worth bloggin!
I was looking to update some functionality in an application which mean't searching through the code for any references to a particular table.
Although there were some references to the table in the pages I also had to ensure that any Stored Procs and Views etc. were also updated.
I used the following useful little piece of TSQL to find the stored procs that contained any reference to my table (obviously change the text "TABLE_NAME_GOES_HERE" below to suit):
SELECT DISTINCT so.name, so.type FROM syscomments sc INNER JOIN sysobjects so ON sc.id = so.id WHERE sc.text LIKE '%TABLE_NAME_GOES_HERE%'
This returns a list like below:
P - Indicate a stored procedure
V - Indicates a view
This is very basic script and can probably be built on i.e. create a SP with this code which accepts the table name as argument etc. but time is limited ATM.