title: Find an object in SQL Server (cross-database)
body: <p>If I've been told a table (or proc) name, but not which connected database the object is located in, is there any simple script to search for it?  Maybe search somewhere in the System Databases?  (I'm using SQL Server 2005)</p>