Thanks for the suggestion regarding "Enterprise Architect" I will investigate it.

Like a lot of us in the MS-SQL DBA world, I do not have the luxury of being a pure DBA. I also have to supply data models and dictionary to Report Developers and the various Application Development teams. It falls to me and my team to ensure that the reference material is current. Especially since we are the ones who built the Data Marts, Warehouses, etc.

I must admit, it is frustrating to have to buy a new license when I have a Visio license. the flip side is i can save $500 per seat by dumping Visio.