SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name = ‘COLUMN_NAME’ );

SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name  like  ‘%COLUMN_NAME%’ );