SELECT distinct object_name(o.id)
FROM syscomments c,sysobjects o
where c.id=o.id
and o.type in (‘P’ ,’FN’)–here ‘P’ for procedure and ‘FN’ for function
and o.category = 0
and c.text like ‘%Hard coded value goes here%’

 

About these ads