mssql sp stored procedure 내용검색

- SELECT

OBJECT_NAME(object_id) AS ProcedureName,

definition

FROM

sys.sql_modules

WHERE

definition LIKE '%검색어%';

 

- SELECT 
    ROUTINE_NAME 
FROM 
    INFORMATION_SCHEMA.ROUTINES 
WHERE 
    ROUTINE_TYPE = 'PROCEDURE' 
    AND ROUTINE_NAME LIKE '%검색어%'; 

 

- SELECT 
    name 
FROM 
    sys.procedures 
WHERE 
    name LIKE '%검색어%';