SQL SERVER 查存储过程内容及名字

SELECT
Name,--存储过程名字
FROM sys.sql_modules AS m
INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id
WHERE o.[type] = 'P' AND M.definition LIKE'%T_MainUser%'