Pls tell me query to find SP's. those were using one perticular column of table.. Why Iam specified that is 'the same colmn is exists in many tables'... at the same time when Iam trying to find the sp's depends on the table, sometimes needed colmn is not using in sp's.
Go to Redgate and download the free utility SQL Search. You can then search all objects in your database for references to that name and find where it is used.