How to know the table name dependence on its column name

select
column_name,table_name,* from information_schema.columns

where column_name like '%isf%'

How to get open SQL connection of databases

SELECT
DB_NAME(dbid) AS DBName,

COUNT(dbid) AS NumberOfConnections,

loginame AS LoginName,

nt_domain AS NT_Domain,

nt_username AS NT_UserName,

hostname AS HostName

FROM
sys.sysprocesses

WHERE
dbid > 0

GROUP
BY dbid,

hostname,

loginame,

nt_domain,

nt_username

ORDER
BY NumberOfConnections DESC;