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:
After deleting this propertie, the appliction saw the database as being brand new and the redeployment succeeded.
Thanks for reading!