How to automatically generate documentation of stored procedures of SQL Server 2008?

Question

How to automatically generate documentatation of stored procedures of SQL Server 2008 like doxygen does to codes? I read about hyperSQL but it doesn't work nice with Windows.

Thanks! Gil.

Answer 1

You can review INFORMATION_SCHEMA.Routines to get a lot of details

http://msdn.microsoft.com/en-us/library/ms188757.aspx