一、存儲過程全局搜索關鍵詞

關鍵詞：text

SELECT ROUTINE_NAME,
ROUTINE_DEFINITION,
*
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%text%';
-- AND ROUTINE_TYPE = 'PROCEDURE'; --存儲過程

觸發器或者存儲過程全局搜索關鍵詞

關鍵詞：text

select name 
from sysobjects o, syscomments s 
where o.id = s.id 
and text like '%Text%' 
and o.xtype = 'P'