A couple of years ago I wrote this small utility to search definitions of tables, views and stored procedures in a live MSSQL or Oracle database. I recently updated the MSSQL interface to support the new object types of SQL Server 2005.
The search functionality covers object names, column names, and object definitions in T-SQL and PL/SQL code, respectively.
You can read more about SchemaFind and download it here.