Hello,

This is a good research work, thanks.

I would also add that when a database is restored / moved from another server the db owner changes in most cases unless it is SA or Domain Login with access to both machines or a standard login explicitly created with the same SID on both machines (the list of exceptions is not possibly complete). We did see ownership issues in this case because DBO user is not mapped to any login which is not expected by most of developers if they move databases themselves in the development environment.

Also many beginners do not realize that by default SQL EM (Enterprise Manager) has a local server registered in the security context of Windows  authentication. So is the default selection when registering the servers. So in many cases when they create objects it is thire Windows login that is the owner.

Yelena.