How To Find Text That Exists In A Stored Procedure, Function Or Trigger



TODO:

Have you ever wanted to find text that exists in a stored procedure, function or trigger using T-SQL?

 

SOLUTION:

 

SELECT DISTINCT *
FROM sys.sql_modules m 
INNER JOIN sys.objects  o ON m.object_id=o.object_id
WHERE m.definition Like '%enter your search criteria here%'
ORDER BY 2,1

 

 

NOTES:

There are no notes on this topic.



Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading