Methods to generate ER diagrams programmatically

Hi All,

Can anyone tell me if its possible to generate ER diagrams programmatically using SQL Server.

Any help would be highly appreciated.

Thanks

-Akash

SQL Server Management Studio has a "Database Diagrams" option under Databases->[database] that may provide a useful visualization of a given SQL Server database.

Hope that helps,

John