Feb 5, 2013 · I want to search a text from all my database stored procedures. I use the below SQL: 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 '%[ABD]%';

Feb 22, 2011 · How to Find a Stored Procedure Containing Text or String. Many time we need to find the text or string in the stored procedure. Here is the query to find the containing text. SELECT OBJECT_NAME(id) FROM SYSCOMMENTS WHERE [text] LIKE '%Text%' AND OBJECTPROPERTY(id, 'IsProcedure') = 1 GROUP BY OBJECT_NAME(id)

Feb 2, 2024 · In this article, we will look into different ways of how to search text in stored procedures and what are the possible uses. A stored procedure generally contains different SQL queries like SELECT query, INSERT query, DELETE query, or an UPDATE query. From the stored procedure we can also call another stored procedure or another FUNCTION.

Jan 28, 2025 · Find text in stored procedures, functions, views, triggers by searching SQL Server system tables using PowerShell and SQL.

Any searching with select statement yield you only object name, where search keyword contains. Easiest and efficient way is get script of procedure/function and then search in generated text file, I also follows this technique :) So you are exact pinpoint.

May 30, 2022 · This query simply utilizes a few handy system tables to search through all the stored procedures in our database looking for procedures that contain a specific word or text. You would replace TEXT_TO_LOOK_FOR with the actual text you want to search for.

This is a simple script working with SQL Sever to find a stored procedure containing a text string. It’s very useful for auditing bad procedures or looking for similarly named fields when you find yourself stuck.

Sep 27, 2021 · In SQL Server, there are many ways to find a stored procedure containing a specific string or text. We will try to cover some standard ways to implement this. The first and simplest way to find a stored procedure with a specific text is by using the sys.procedures.

Feb 18, 2025 · Here are two common methods to achieve this: Method 1: Using syscomments. The syscomments system table stores the text of SQL objects, including stored procedures. By querying this table, you can filter for procedures containing …

Jul 29, 2020 · In this tutorial, we’ll discuss on how to find Stored Procedures, Views and Functions which contain a particular text in it. Also, we’ll discuss on how to find tables which has a column name with a particular text. To demonstrate this topic, SQL Server 2008 R2 Express version is being used. The exact version information is.