Finding Objects on Your SQL Instance

DECLARE @Cursor CURSOR
DECLARE @DatabaseName VARCHAR(100)
DECLARE @Object VARCHAR(100)
DECLARE @Message VARCHAR(100)

--Enter object you are trying to find:
SET @Object = 'YourTableName'

SET @Message = 'Object found in database: '
SET @Cursor = CURSOR FOR
					SELECT
						name
					FROM
						sys.databases
					WHERE
						[state] = 0 --0 = Online

OPEN @Cursor
FETCH NEXT FROM @Cursor INTO
							@DatabaseName

WHILE (@@FETCH_STATUS = 0)
BEGIN

	DECLARE @SQL VARCHAR(MAX)
	SET @SQL = 
	
	'
	IF (SELECT COUNT(0) FROM [' + @DatabaseName + '].sys.objects WHERE name = ''' + @Object + ''') > 0
	BEGIN
	PRINT ''' + @Message + @DatabaseName + '''
	END
	'

	--PRINT @SQL
	EXEC (@SQL)
	FETCH NEXT FROM @Cursor INTO
								@DatabaseName

END

CLOSE @Cursor
DEALLOCATE @Cursor