DBDocumentor 

Document and report on the SQL objects making up your SQL Server database. DBDocumentor describes functions, indices, procedures, tables, triggers, views and constraints of your databases. Output options include colorized source code and XML.
sql reports documentation reports sql table index stored procedure constraint

SQL Documentation Tool 

Automatically documents Microsoft SQL Server databases. Documentation is created in HTML , HTML Help and text formats.
sql server documentation transact sql triggers tables stored procedures tables views columns html help html document

SQLHelp 

Annotate and document the SQL stored procedures driving your web application. SQLHelp describes the parameters, output result sets and transactional nature of each procedure. Output options include colorized SQL listings.
stored procedure stored procedures annotation of sql