SQL Server provides three methods for searching stored procedures that contain a keyword.

Example 1

The code is as follows:	Copy code
Select OBJECT_NAME (id), id from syscomments Where id in (Select object_id (name) from dbo. sysobjects where xtype = 'p' ) And text like '% FieldName %' Group by id

Example 2

In Database SQL Server 2005/2008, query stored procedure statements that contain a keyword:

The code is as follows:	Copy code
Select distinct B. name From dbo. syscomments a, dbo. sysobjects B Where a. id = B. id and B. xtype = 'p' and a. text like '% text %' Order by name

Example 3

Keyword search related stored procedures, triggers, functions, and views

The code is as follows:	Copy code
Select name, type_desc from sys. all_ SQL _modules s inner join sys. all_objects o on s. object_id = o. object_id where definition like '% keyword % 'Order by type_desc, name