table1   tinyint   0
table1   tinyint   2
table1   tinyint   3
table2   bit       0
table2   bit       1

	SELECT
		[TableName] = so.name,
		[Type] = st.name
	FROM
		sysobjects so,
		syscolumns sc,
		systypes st
	WHERE
		so.xtype = 'U'
		AND
		sc.id = OBJECT_ID(so.name)
		AND
		sc.name = 'status'
		AND st.type = sc.type

set nocount on

declare	@ColumnName varchar(50),
	@StageID	int,
	@Cmd		varchar(8000)

set	@ColumnName = 'Status'

-- stage the TableName, etc of each table that has the column
declare @Stage table (StageID int identity(1,1), TableName varchar(100), ColumnName varchar(100), DataType varchar(100))
insert into @Stage (TableName, ColumnName, DataType)
select	st.name,
	@ColumnName,
	stt.name
from	sys.columns sc 
join	sys.tables st on 
	sc.object_id = st.object_id
join	sys.types stt on
	sc.system_type_id = stt.system_type_id
where	is_ms_shipped = 0 and
	sc.name = @ColumnName

-- create temp table to hold select results
create table #Result (TableName varchar(100), DataType varchar(100), RowValue varchar(100))


-- loop through, construct insert statements for first 3 rows of each table
select @StageID = min(StageID) from @Stage

while @StageID is not null
begin
	select	@Cmd = 'set rowcount 3 insert into #Result select ''' + TableName + ''', ''' + DataType + ''', cast(' + ColumnName + ' as varchar(100)) from ' + TableName + ' (nolock) set rowcount 0'
	from	@Stage
	where	StageID = @StageID

	--print @Cmd
	exec(@Cmd)

	select @StageID = min(StageID) from @Stage where StageID > @StageID
end

-- return results
select * from #Result

-- clean up
drop table #Result

set nocount on