I created a data model in Visio AE 2003 and went through the extremely tedious task of putting a note on just about every column. Unfortunately when I generated the DDL the notes on the columns were simply generated as commented lines that don't do much more than annotate my DDL. Not exactly what I was hoping for. So after quite a search on the web I came across this article form Alberto Ferrari.
It seems Alberto had come across the very same problem and decided to put together a nice little console app to parse the DDL and append the needed calls to sp_addextendedproperty statements so that the notes in Visio are added to the Description value of columns in SQL Server.
Nicely done Alberto. This saved me a lot of work.
--chaz