Find All Tables for a Particular Field name in Sql Server

SELECT sysobjects.name
FROM syscolumnsleft join sysobjects on sysobjects.id = syscolumns.id
WHERE syscolumns.name like 'OBRNo'