look at this post:http://qa.sqlservercentral.com/scripts/Metadata/64603/
or try this:
SELECT syscolumns.name AS ColumnName,
systypes.name AS Datatype,
syscolumns.length AS Length
FROM sysobjects,
syscolumns,
systypes
WHERE sysobjects.id = syscolumns.id
AND syscolumns.xtype = systypes.xtype
AND sysobjects.name =...