-- SEARCHING FOR A SPECIFIC OBJECT CROSS DATABASE SELECT * FROM Sys.Objects WHERE 1=1 AND name = '%HERE_THE_NAME_OF_OBJECT%'