Object search within Management Studio of SQL Server 2008
Good news for the Development DBAs to have a fature of searching for a particular object within the SQL database.
The newest feature to SQL Server 2008 version will be 'object search'!
Until now even for me I used to refer to ThisArticle to search for a specific object within the SQL Server database, also this you can easily enter the full or partial string to match within that database. I feel this is included after the connect feedback here in asking for such an inclusion,
Further if you want to achieve using a TSQL code I found this BlogPost that can be use against all databases too.