searching object across the databases.

SET QUOTED_IDENTIFIER ON
GO
sp_msforeachdb "use ? ; SELECT name AS Table_Name,xtype AS type,’?’ AS DB_Name FROM sysobjects WHERE name LIKE ‘object_name%’"