DB object ownership problem.

Hi

(Please refer to attached screen shot)

I log into a SQL Server 2005 database using account admin_cbp_test and create a simple table, the table then has admin_cbp_test ownership, but I want the table objects always to have dbo ownership. How do I achieve that? Can I only do this with an sa account or can I add the user to a particular to achieve same result?

Thanks.
Image1.png
jonatecAsked:
Who is Participating?
 
QPRConnect With a Mentor Commented:
create table dbo.tablename
...
0
 
jonatecAuthor Commented:
Great thanks !
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.