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;
GO
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)';
GO

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);

image