select syscolumns.name,systypes.name as type from syscolumns 

 inner join sysobjects on syscolumns.id  =  sysobjects.id 

 inner join systypes on syscolumns.xtype   =   systypes.xtype 

 where (sysobjects.name   =   '" + tableName + "')   

    and (systypes.name   <>   'sysname')