Hi Kris,

this is the same query for SQL 2005:

select SO.name as 'table', SC.name as field,

ST.name as datatype, SC.max_length as 'size',

sp.value as 'description'

from sys.columns SC inner join

sys.objects SO on SC.object_id =...

dbdesc (mentioned earlier in this thread) can generate Word 2003 and RTF documents among others. It uses XSL templates so the output can be fully customized.

Additionally, it includes a built-in...