Personally I love ApexSQL products. They have one called ApexSQL Doc.
This will document the entire database including any objects, ssis, ect.
You can select the databases, tables, functions, SPROC's, SSIS, ect that you want or don't. It includes text documentation, UML, relationship diagrams; and so-on.
Very Very good stuff.
<hr noshade size='1' width='250' color='#BBC8E5'>