Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
As it is not possible to use the interface to check the database properties, it cannot be seen if there is a database owner present for the
database, or if an owner is present, then what is the name of that account. To verify the owner of a database run the below query.
Once it has been identified that there is no database owner or the login does not exist any more, the command below can be used to
change the database owner to a different account.
EXEC sp_changedbowner 'SA';
After running the above command, the properties of the database can now be opened without any error. Instead of the 'SA' account
you can now choose any login which exists in the SQL Server instance and is valid. However it is important to note that after sp_changedbowner
is executed, the new owner is known as the dbo user inside the database. The dbo has implied permissions to perform all activities in the database.
This allows the database owner to perform all operations inside the database including dropping the database itself.