Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
olily
Starting Member
37 Posts |
 Posted - 2002-05-17 : 01:05:37
|
| How can I change the owner of tables to other? For example I have 5 tables with dbo as owner. I wish to change it to abc as owner. I'm using Sql Server 7.0 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-05-17 : 01:40:36
|
| sp_changeobjectowner-Chad |
 |
|
|
olily
Starting Member
37 Posts |
Posted - 2002-05-17 : 03:31:52
|
| I can change my table's owner from dbo to abc. But when I tried to change back to dbo, I received this error message "ActivityLogs does not exist." where ActivityLogs is the table in my database and does exist. abc's server roles are system administrators and database creators to my database. Whereas database roles are public and db_onwer. Please advice. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-17 : 08:40:15
|
| Once you name it abc.ActivityLogs, you always have to refer to it like that, even when using sp_changeobjectowner. The only time you can get away with leaving off the owner name is when it's owned by dbo. |
|
|
|
|
|
|
Table Owner