Got this somewhere (sorry forgot where) and I use instead of missing "object search" in SQL 2005

Change the "where" clause to limit to object types you want to search

DECLARE @SEARCHSTRING...