In my project i have create more sps. sometime i forgot spname that time i’m using this query to search sp.

Find Sp Given Keyword

–Find SP
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 ‘%STUFF%’;
Advertisements