Unfortunately there is no magic wand to do this, so its a pain staking trawl through all SP's, as people may have used Aliases, etc.

You might be able to get an Idea of the scale by using the

Select * from sys.syscomments

WHERE [TEXT] Like '%TABLEA.ID%'

But for long SP's you may need to link these together using the Id and colId references.

Select distinct

SCHEMA_NAME(schema_id) AS [Schema_name]

, Objects.name Object_Name

from sys.syscomments

INNER JOIN sys.objects on objects.object_id=syscomments.id

You could reverse engineer the database into an SQL server Project if you have VS2008 GDR or VS2010 Premium (I think).