The Internet of Things (IIoT) offers unprecedented possibilities for industries. Stay ahead with EcoStruxure™ Plant and Machine.Learn more
...with the EcoStruxure™ Facility Expert (formerly known as 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
The story behind the Shedd Aquarium, a smart, sustainable facility that connects people to animals, with EcoStruxure™.Discover how
Welcome to the Schneider Electric Global Website×
*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.
Sign up for all the latest solutions, offers and best practices straight to your inbox.
We are excited that you have joined the group. You will receive your welcome email soon describing the program and what to expect in the upcoming weeks. Enjoy!