Find a character or string with in procedures or views or triggers
Find a character or string with in procedures or views or triggers SELECT DISTINCT so . name , sc . text FROM syscomments sc INNER JOIN sysobjects so ON sc . id = so . id WHERE so . xtype in ( 'P' , 'TR' , 'V' ) and sc . TEXT LIKE '%sy%' order by name