Database Extended Properties

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!

Leave a Reply

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

You are commenting using your 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 )

Connecting to %s