SQL Server 2008 search

How to search inside a Stored Procedure in SQL Serve开发者_高级运维r 2008?

---

If you are looking for the searching for specific key in definiton of a stored procedure use INFORMATION_SCHEMA.ROUTINES along with OBJECT_DEFINITION function.

SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE OBJECT_DEFINITION( OBJECT_ID(SPECIFIC_NAME)) LIKE '%<YOUR_KEY>%'