The SQL Server Enterprise Manager does have the ability to create a diagram of the physical model of a database. You might want to try it. If that doesn't meet you needs, take a look at ERWin, although it is a little pricy.

-Mike