SQL Server: Finding Text in Database Object

I use this query quite often. A large database and working in team often making we need to find database object that contain a particular keyword. I am a person who sometimes difficult to remember hehe.... So I make this note just in case need it one time.
SELECT o.name 
FROM   sysobjects o 
       JOIN syscomments c ON o.id = c.id 
WHERE c.text LIKE '%keyword%'

Click here if you like this article.


Post a Comment

0 Comments