I am trying to find a way to capture the comments from stored procedures in our SQL DB as a start to trying to gather info for our data governance and quality initiative. Helping to understand what was done and why and potentially using it for some documentation in our data/business/metadata catalog. I've found ways to replace them but am not savvy enough to transition that into capturing them.
Any help would be appreciated.
Thank you- HS