Do you mean adding the user login to the do_owner role?


>Great question. I don't know of any way to do this besides logging into sql server as the login that is mapped as DBO for the target database.
>
>-Mike
>
>>While at the GLGDW Mike Levy pointed out to me that prefixing all your tables with "dbo." will give you a performance gain. This is because SQL server will look for a table under the login name first and then default to dbo. So, now knowing this is there any way to tell SQL Server to use dbo as the default owner when I run a query that doesn't prefix "dbo" to all the table names. I really dont want to go though all my stored procedures and add dbo.
>>
>>
>>Eric