Nice summary.

The one thing that puzzles me is that in SQL6.5 we used the sp_addalias in order to alias users to the dbo as there wasn't a db_owner role.

This got around the business of accidentally creating objects not owned by the dbo.

The current books online says that this practice is only included for backwards compatibility. The implication of this is that

a) It is going to be made obsolete at some time in the future.

b) Its use is frowned upon.

Frankly, I find the db_owner role a bit of a red herring given the non-dbo owned object pitfall and that sp_addalias works fine.

What are your views on this?

========================

He was not wholly unware of the potential lack of insignificance.