获得Sql Server2000的字段注释

select so.name as table_name, sc.name as column_name, sc.xtype as data_type ,sp.value as remarks from sysobjects so left outer join syscolumns sc on so.id = sc.id left outer join sysproperties sp on sc.id = sp.id and sc.colid = sp.smallid where so.type = 'u' and so.name='T_CKey' order by so.id, sc.colorder