Search Stored Procedures in MS SQL 2005

Sometimes when looking for a bug in web software, you need to find everything that touches a particular database table. In Visual Studio, this is as simple as a global search. But in SQL, you might also want to find every stored procedure that references that table. A quick search online found a great little SQL script that does just that. Here’s what to do:

SELECT Name

FROM sys.procedures

WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%tblMyTable%'

GO

Thanks to SqlAuthority.com for this code snippet.