It's the syscomments table.  A bit confusing I know because "comments" in oracle are documentary, but in sql the TEXT column of syscomments provides the text of the stored procedure, function or view.

Documentation in SQL Server is often (if at all) provided through the definition and use of extended properties.