Change owner of a Microsoft SQL Server database
We had a spaghetti of database owners so I decided to get this straightened out. How to do it? Simple!
– Open New Query in SQL Server Management Studio in the database that you want to change the owner
– Run EXEC sp_changedbowner ‘domain\owner’
– Wait for Command(s) completed successfully.
As simple as that!