Automated SQL documenation?

I am an intern at a university and we are looking for a way to automatically document tables, queries, etc. ColdFusion is the platform used, and SQL Server 2000. Is there a way to have the documentation performed that will capture tables, constraints, etc.? I have found some, but so far, none are working. Please help if you can!!! :confused:SQLDMO would be my first choice, SQL-EM (Enterprise Mangler) would be a tolerable interface if you don't want to code your own.

-PatP|||ditto all 'dat

+

there are LOTS of sp_helpthisthatandwhatever you can use to get all that info if you're not a VB guy.
same stuff EM ends up using to populate its forms, but i like it mo' betta.|||What kind of documentation do you want? Relationships and dependencies and such? Who is the intended audience and what will they be doing with the information?|||I made it a habit to create data diagrams for every db I'm working with.