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.
0 Comments