Changing dbo (database owner)

Sometimes you need to change the user (login) that owns a database.

For example, you may need to restore a database backup, and the user that made the backup is not a user on your current machine.

There's a Sql Server sproc (stored procedure) to change owner: sp_changedbowner.