search for data table in stored procedures

[gajesh]

Hello,
I got huge database containing hundreds of stored procedures. I need to modify fields of some of the tables which might affect some of the stored procedures. Neither I have documentation about the stored procedures nor the test cases. I am very new to this project and don't have much idea about it.

Is there any way i can come to know that what are all the stored procedures which is using the particular table, i am going to modify? Any search or some thing like that..

P.S.: I am using SQL server.

Thanks in advance.

[Alsvha]

If you right click a table in the object manger, and then select "view dependencies" (version 2005+ I believe), you should see a list of elements which refer to your table.
Perhaps that'll be enough for you :)

[gajesh]

Thanks Alsvha.