SQL SERVER 非常好用的根据某个关键字查存储过程:
select * from sys.all_sql_modules where definition like '%wxface%'
或者
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 '%WxFace%';