Get database name of a table/stored procedure

create table #t (
    DBName sysname not null
)
go
exec sp_msforeachdb 'use [?]; if OBJECT_ID(''schema name.table name/stored procedure name'') is not null insert into #t (DBName) select ''?'''
go
select * from #t
go
drop table #t

Search details of a sql table

To get details of a table

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME like '%tablename%'

To get all dependencies of a table via script

SELECT referencing_schema_name, referencing_entity_name,
 referencing_id, referencing_class_desc
FROM sys.dm_sql_referencing_entities ('dbo.Address', 'OBJECT')
GO

To get stored procedures referencing a table

SELECT name, OBJECT_SCHEMA_NAME(object_id)
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%tablename%'

Dependencies of a stored procedure

https://technet.microsoft.com/en-us/library/ms345404(v=sql.110).aspx