Extract documentation strings from SQL Scripts
You should try Natural Docs to document SQL-procedures. It is open-source, really straight forward and well documented. An example would look like
/**
* This is a stored procedure.
*
* Parameters:
* foo - foo does bar
*/
create procedure my_proc(foo varchar(100)
...
GO
The output is generated as nice-looking HTML. You can specify custom sections for return-values, date and author, or include usage-guidelines and code samples in your output. Have fun!