Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used to find out the list of all the stored procedures which contains a particular given text as input.
SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id)
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE ‘%Given text%’
Discover more from Technology with Vivek Johari
Subscribe to get the latest posts sent to your email.
