Solved

database identification

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

808 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