Does anybody know a great and free Database Designer in a position to export the look into SQL Server 2005 ?

I've been using PowerAMC for just two days however it was the trial. PowerAMC may be the only program I understand having a Conceptual Data Model Designer.

Thanks.

NORMA? A connect for Visual Studio (may use Express models)

This really is helpful for Conceptual Data Modelling and can generate DDL too