Change ownership of MS SQL 2014 database

Check ownership of databases

select name,suser_sname(owner_sid) as Owner
from sys.databases;

Alter ownership

alter authorization on database::"MY DATABASE" to sa;

Leave a Reply