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?
LVL 1
ivanhAsked:
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).
0
 
dtomynCommented:
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".
0
 
ivanhAuthor Commented:
dtomyn - That answer is acceptable to me.

Lock it and I will award
0
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.