Solved

database identification

Posted on 2014-10-22
4
111 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:ScottPletcher
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:
ScottPletcher 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now