Month: October 2019

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;