DEV Community

CodetoLive blog
CodetoLive blog

Posted on • Originally published at codetolive.in on

How to search for text in a SQL Server stored procedure, function, or view?

You can use the following T-SQL query to search for text in a SQL Server stored procedure, function, or view.

Code:

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 '%search term%'

Enter fullscreen mode Exit fullscreen mode


Fig 1. Search text in stored procedure, function and view using t-sql

Top comments (0)

Postmark Image

Speedy emails, satisfied customers

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.

Sign up