Solved

database identification

Posted on 2014-10-22
4
114 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL DATEADD 10 81
partitioning database after decade growth 8 60
SQL Sum of items in two tables not equal. 5 49
Finding Where Clause Value in SQL Views and SP 21 42
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
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.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

726 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