Database Extended Properties

DBA 1 Minute

A very short blog today, but maybe something that might help you when facing an issue.

Some applications use the exenteded properties of a database to keep track of a minimal version, to claim ownership or to mark a database as a specific type of database, for instance a repository database. When that same application starts throwing errors about the database, the extended properties are worth looking at.

Today I faced an issue where a redeploy of a repository failed on a cleaned database. The error was that the database was already in use as a repository database. But, there was nothing in it. We thought. Untill we looked at the extended properties. There was this field:

Who are you?

After deleting this propertie, the appliction saw the database as being brand new and the redeployment succeeded.

Thanks for reading!

Published by reitsees

Reitse began his computer days with GW Basic and quickly followed with Windows 3.11. After that many computers followed and, interrupted by human resource and psychology studies, he got into the IT work field around 2007. There he met Oracle 9. With a command line from 1980. At his current job he met SQL Server. And loved it. Now he’s working with SQL 2008 to SQL 2019 on-premises and a number of Azure SQL Databases, supporting customers and tuning databases. New projects focus more on the Azure data platform as an architect, security advisor and data engineer.

Published

Leave a Reply

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

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

Cancel

Connecting to %s