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?
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you just do table(columns) and you have sa permissions it will always defualt to dbo.table