Changes the default database owner in SQL Server 2008

Question

How can I change the default database owner when creating a new database in SQL Server 2008.

Answer 1

ALTER AUTHORIZATION ON DATABASE::MyDB TO sa;

Note, this doesn't add the new owner to db_owner (sa + sysadmin map to dbo user which is different)