Nivedita’s Weblog

Hi

These are the 2 queries to get the Sored Procedure details related to a Particular Database and Particular Table.

use db name

Select * From sys.sysobjects where type=’p’

SELECT * from sys.sysobjects so
inner join sys.syscomments sc
on so.id=sc.id
where type=’p’ and sc.text like ‘%TableName%’

where p stands for the sproc.