Stored procedure in a table

Question

Hi.. Any one can u tell me How to get name of all stored procedure which are used in a table? Thanks

Rajeswari nathan · Answer

Nice This answer is helpful for me.

Purushottam Rathore · Answer

Thanks for reply. My question is how to find stored procedure which are related to particular table. Well i have found the solution. SELECT DISTINCT sp.name as StoredProcedureName FROM syscomments scomment INNER JOIN sysobjects sp ON scomment.id=sp.id WHERE scomment.TEXT LIKE '%BannerStatistics%'

Roei Bar · Answer

if you are looking for all sp used in specific DB you can use select * from sys.objects where type='p' or i am missing something