[MSSQL]sys.sql_modules 找某個關鍵字Keyword在哪些物件中出現

-- =============================================
-- Author:		Steven玄
-- ALTER date:  20210120
-- Description:	找某個Keyword在哪個物件中出現!
-- =============================================

SELECT distinct object_name(object_id) as [物件名稱], definition as [物件內資訊]
FROM sys.sql_modules
WHERE definition LIKE '%關鍵字串%';

-- =============================================
-- Author:		Steven玄
-- ALTER date:  20210120
-- Description:	找某個Keyword在哪個Stored Proceduce中出現!
-- =============================================

Select distinct object_name(object_id) as [物件名稱], object_definition(object_id) as [物件內資訊]
from sys.procedures
Where object_definition(object_id) like '%關鍵字串%';