Solved

database identification

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL server is using more virtual memory. 5 83
TSQL previous 5 33
Alter a column in sql 34 30
Problem with SQL Script - Cannot call methods on char 2 20
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
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 tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

806 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