SELECT OBJECT_NAME(object_id)

FROM sys.sql_modules
WHERE definition LIKE '%keyword to search%'

或者

SELECT DISTINCT o.name AS Object_Name,o.type_desc
FROM sys.sql_modules m
INNER JOIN sys.objects o
ON m.object_id=o.object_id
WHERE m.definition Like '%keyword to search%'