<div>
My understanding is that you can't. &nbsp;The best you can do is change the object's owner after creation or create it as &quot;dbo.objectname&quot;.
</div>


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".

<div>
dtomyn - That answer is acceptable to me.<br />
<br />
Lock it and I will award
</div>


dtomyn - That answer is acceptable to me.

Lock it and I will award

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


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?

sp_addalias and sp_addrolemember

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.