This might be a start:

select

so.[name],

ac.[name],

st.[name],

st.prec,

st.scale

from

sys.all_columns ac

inner join sys.objects so on so.object_id = ac.object_id

inner join msdb.sys.systypes st on st.xtype = ac.system_type_id

where

so.type = 'U'

order by

so.[name],

ac.[name],

st.[name]

Good idea checking SYSPROCESSES, rbarryyoung. I'll give it a try. I won't worry about SQL 2000. Although I can't have the code falling over, I'm prepared to disable...