Today I stumbled on a great tool for documenting your database SqlSpec 3.7 from Elsasoft.
SqlSpec will generate easy-to-read database documentation for any of the following platforms:
You can read more about the many features of SqlSpec here.
But we as System Center specialists are probably mostly interested in our SQL Server 2005 OperationsManager, OperationsManagerDW and ReportServer databases;-)
So I connected SqlSpec to my OperationsManager database and let it run (for some time).
And when it's finished you can view you the complete OperationsManager database in a Compiled HTML file or in a Webbrowser. You even have a Dependency Graph for for instance the Alert Table. How cool is that!
If I find more interesting info with this tool about the OperationsManager databases I'll let you know.