As much as I hate searching for objects or not having complete information to troubleshoot an issue sometimes I have to go search for a table in the database.
To find which database contains a table I am looking for on a server I run the following script
-- SEARCH FOR OBJECT
-- FIND A TABLE IN ALL DATABASES ON SERVER.
EXEC sp_msforeachdb N'USE [?];
@@SERVERNAME + '' | '' + SUSER_SNAME() + '' | ''+ DB_NAME() + '' | '' + CONVERT(VARCHAR(20),getdate(),120) as [SOURCE],
TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME ,
''[''+ CAST(@@SERVERNAME AS VARCHAR(100))+ ''].[''+ TABLE_CATALOG + ''].[''+ TABLE_SCHEMA + ''].[''+ TABLE_NAME + '']'' as [FQN]
FROM [?].INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE ''%mytableName%'';
I combine this with registering a group of servers in management studio, and in one quick step I can search for a table in any set of servers and databases.