Link to home
Start Free TrialLog in
Avatar of yanci1179
yanci1179

asked on

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?
Avatar of gigglick
gigglick

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
Avatar of yanci1179

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of gigglick
gigglick

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial