I keep a corresponding dictionary database for every database I design with descriptions of the tables, views and columns.  Good idea to add stored procs, I hadn't thought of that.  I'm required to document data classification (you know what's sensitive and what's not), so that's in there too.  For that last database I developed, all the columns are populated from a non-windows system so I added the source information too.  Now I can talk to the admins on that system in their terms if I need to.