This article is tagged with:
T-sql find object by name
and mysql
t-sql find object by name
-- SEARCHING FOR A SPECIFIC OBJECT CROSS DATABASE
SELECT
*
FROM
Sys.Objects
WHERE 1=1
AND name = '%HERE_THE_NAME_OF_OBJECT%'