The business layer is in the base in triggers and procedures.
Task: Organize detailed documentation of database entities and also organize documentation of business processes related to these entities.
What now? Now documenting stored procedures and triggers occurs through one big comment at the beginning, describing the entire history of changes and a bunch of comments within the procedure. Database entities, such as tables, views, etc., are documented using Extended properties.
The whole thing is not always convenient. Almost never. It would be desirable that a single description of the business process was stored somewhere and the database entities with detailed documentation were attached to this description.
The question is how to organize this documentation. If you do not know the direct answer to a question, then you may be able to share how you are documenting the database. This will also be useful. Thank.
