Find text in SQL stored procedures

Method to retrieve every text inside the stored procedures of a database

SELECT B.Name, *
FROM syscomments A INNER JOIN sysobjects B
ON A.id = B.id
WHERE A.text like '%tblNames%'

Print | posted on Monday, February 02, 2009 12:43 AM | Filed Under [ SQL ]

# re: Find text in SQL stored procedures

This came in handy!

2/2/2009 12:14 PM | Jef Claes

thanks.. its really helpful.

2/10/2009 3:07 PM | Josh