Extended Database Properties

When there are hundreds of databases in a SQL Server estate, its good to make use of extended properties and give each database a description. When some of these databases rarely get looked at, and others are automatically named through an application install, it can become difficult to manage and to handover.

Just as an example, when installing Microsoft Lync 2010, it creates 11 databases (depending on the install) and some are inconspicuously named rtc & xds.

To create an extended Property with description information:

USE rtc;
EXEC sys.sp_addextendedproperty 
@name = N'Database Description', 
@value = N'Microsoft Lync 2010 - Persistent user data (for example, ACLs, contacts, home server or pool, scheduled conferences)';

The following example displays all extended properties set on the database itself.

SELECT objtype, objname, name, value
FROM fn_listextendedproperty
(default, default, default, default, default, default, default);



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: