Stored procedure in a table

Nice,
This answer is helpful for me.

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 Bar17y ago

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