In my company, I've been assigned the task of researching the process of setting up a "data dictionary" for all of our Sql Server data (tables, fields, userid's, passwords, etc). In particular, our company wants to know what the corporate standard is for data dictionary's.
I've seen a few different online examples of setting up a data dictionary by filling in the "Description" box in each table field however I don't know if this is the common corporate approach. Would purchasing some type of software be the better approach (although we're not looking for full fledged data modelling at this point, so I think something like ErWin is a little too expensive for what we're looking to accomplish at this point).
Thanks for you help.
-Goalie35