look at this post:http://www.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 =...

thanks guys.

i eventually came up with this but i think i am going to stick with my first bit of code:

SELECT

sp_id,coname