sp_addalias and sp_addrolemember

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?
Who is Participating?
dtomynConnect With a Mentor Commented:
OK, thanks!  

Also, you will notice that Experts-Exchange now has given the ability to questionnaires to accept a comment as an answer (just for future reference).
My understanding is that you can't.  The best you can do is change the object's owner after creation or create it as "dbo.objectname".
ivanhAuthor Commented:
dtomyn - That answer is acceptable to me.

Lock it and I will award
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.