select
distinct object_name(id) from syscomments
where
id in (select object_id from sys.objects where type ='P')
and text like '%table name%'