This should work as well:

set nocount on

declare @results table ([ID] INT identity (1,1) not null, colname varchar(500), tablename varchar(500))

insert into @results

select sc.name, so.name from syscolumns sc inner join sysobjects so...