—将text替换成你要查找的内容
    select name
    from sysobjects o, syscomments s
    where o.id = s.id
    and text like ‘%text%’
    and o.xtype = ‘P’

    —将text替换成你要查找的内容
    SELECT ROUTINE_NAME, ROUTINE_DEFINITION
    FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_DEFINITION LIKE ‘%text%’
    AND ROUTINE_TYPE=’PROCEDURE’