Change Database Owner

Here is something I perform so rarely I can never remember how to do it.  If a databases is created and no owner is specified, it will make the current user the owner.  If this is not what you intended you can change the owner of the database with one of the following methods.

To change the database owner the old way:

exec sp_changedbowner [sa]

or the new way:

alter authorization on Database::<DBName>
to [sa]

I'm pretty sure the old way is deprecated and the new way is the preferred method.