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

Answer 1

Nice,
This answer is helpful for me.

Answer 2

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%'

Answer 3

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