Procurar objetos (existeem)

EXEC sp_MSforeachdb 'USE [?]   

SELECT distinct

OBJECT_NAME(cmt.ID) OBJECT_NAME,

db_name() banco,

Case

  WHEN (obj.xtype = ''P'')  THEN ''Stored Procedure''

  WHEN (obj.xtype = ''V'')  THEN ''View''

  WHEN (obj.xType = ''TR'') THEN ''Trigger''

  WHEN (obj.xType = ''FN'') THEN ''Função''

  WHEN (obj.xType = ''U'')  THEN ''Tabela''

  ELSE ''Outros''

END TipoEstrutura

FROM        SYSCOMMENTS cmt

inner join sysobjects obj

on cmt.ID = obj.id

WHERE        TEXT LIKE ''%tbdw0020%'' '