• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1506
  • Last Modified:

SQL 2005 dbo owner on tables

I am logging in as

ausername (sa permissions)

Then I am creating tables and they default to owner dbo.  I tried

Use datbasename

exec sp_changeDBOwner owner

created the tables but it is still creating the tables with 'dbo'  any idea?
  • 2
1 Solution
when you create the tables create them as user.table(my columns).  

If you just do table(columns) and you have sa permissions it will always defualt to dbo.table
yanci1179Author Commented:
can i change the permissions so the default goes to the user name?  What permissions should I use?  I need to create database, tables, updates, inserts, deletes, into the created objects.
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now