Script to Find any Objects in SQL Server

This T-SQL script will help you find an object in your Server. It will go over all of your databases and see in which database you have this object.

• this is the poor man RedGate :).

sp_MSforeachdb 'select db_name(), * From ?..sysobjects
 where 
  xtype in (''U'', ''P'') And upper(name) like ''%Object_Name%'''