Sometime ago, I needed to find a particular string somewhere in my database but didn't want to spend hours/days searching for it. I found this little procedure in sqlserver magazine's website. Very useful:

USE [DATABASE_NAME] --this should change to whatever your database name is
GO
/****** Object: StoredProcedure [dbo].[Find] Script Date: 02/09/2009 09:46:53 ******/
SET ANSI_NULLS ON