--try
declare @col varchar(4000),@sql varchar(4000)
set @col=''
select @col=@col+','+name from syscolumns where id=object_id('表名') and status<>128
set @col=stuff(@col,1,1,'')
set @sql='insert into tb('+@col+')select '+@col+' from 另一数据库名.dbo.表名'
exec(@sql)