Persons familiar with TOAD for Oracle know about the fairly elaborate search function that lets you search for particular text in procedures, functions, views, column names, triggers, pretty much anything.
There's a way to do that in SQL Server as well, though you kind of have to "do it yourself."
Use the query below. Make sure that you are "in" the database that you mean to search before you run this query.
select
* from sysobjects o, syscomments c where o.id=c.id
and
c.text like '%your search text here%'
You can also limit your search by object type. For example:
select
* from sysobjects o, syscomments c where o.id=c.id
and
c.text like '%mysearchstring%'
and
xtype='P' --search stored procedures only
The complete list of types is below. For more information, see:
http://articles.techrepublic.com.com/5100-9592_11-6142579.html
C: Check constraint
D: Default constraint
F: Foreign Key constraint
L: Log
P: Stored procedure
PK: Primary Key constraint
RF: Replication Filter stored procedure
S: System table
TR: Trigger
U: User table
UQ: Unique constraint
V: View
X: Extended stored procedure