addalias was nice in that when objects were created, they were created under dbo. I tried using addrolemember and added my user to db_owner, but when the objects are created, they are created under that user account. I want the objects created under dbo. sp_addalias is still available in 7.x, but they say it's for backward compat.
REAL QUESTION: In MS vision, how can I get the same exact benefit as sp_addalias?