Get the Database name with the object name in SQL Server

EXEC sp_msforeachdb
‘if exists(select 1 from [?].sys.objects where name=”usp_mystoredprocedure”)
print “?”‘

Difference between Stored Procedure and Function – SQL Server