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 '%YourText%'
Programming is fun and interesting. As you all know, sometime we programmers stucks in the middle way of coding without getting a solution. Blogs like this will help us to find a path to solve our problems. The contents of this blog are the solutions that I found by myself and from other sources. Sharing such solutions is also interesting. Thank you!
Showing posts with label Search Inside database. Show all posts
Showing posts with label Search Inside database. Show all posts
Sunday, October 28, 2018
Search Inside a SQL Procedure
Subscribe to:
Posts (Atom)