Solved

database identification

Posted on 2014-10-22
4
115 Views
Last Modified: 2014-10-23
My environment is basically 2008 or 2012 sql servers.  I have about 80 databases.
I am using management studio.

when you select a database with management studio... is there anywhere to put comments or notes on what a database is....  example.  
database name   Accounting
can I right click and add a notation that would say something like.    "Accounting database was created in December of 2009 and is used for record keeping for the year 2009 associated with hog trading"

if not... whats the best way that someone can access databases with studio and see a description of the database
I would like to get away from excel and have the databases be self identifying and documented.
0
Comment
Question by:jamesmetcalf74
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 40398001
MS provides "extended properties" to do that.

They're quite flexible, and you can view, and modify, them directly in SSMS.  Right-click on the db name, select "Properties", then select the "Extended Properties" tab.  Put a key value in the "Name", for example "Description", then type your comments in the "Value" section.

You can also use SQL-provided stored procs to work with extended attribs.  They take getting used to, but you should make the effort, as they can help automate the documentation process.  See "sp_addextendedproperty" and similar procs in BOL.
0
 

Author Comment

by:jamesmetcalf74
ID: 40398066
so for instance
I just put Description in the Name and Development database for the Value
These changes affect the database in no way whatsoever?
Thanks Scott
0
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 500 total points
ID: 40398114
Correct, no affect on performance, zilch.

You can add as many different extended properties as you want, just give each a unique name:
Description / Description2 / ...
Description_Developer / Description_DBA / Description_User / ...

Be aware, though, that if you DROP the db -- for example, because you plan to restore it again immediately afterward -- the extended properties will be lost.
0
 

Author Closing Comment

by:jamesmetcalf74
ID: 40399703
Thanks Scott-
We are going to use your recommendation.
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question