Hi all
I'm having a problem assigning ownership on a table to dbo. The database is owned by dbo, but for some reason one of the tables is owned by a windows user. When i try to assign ownership to dbo, i get the following error:
Cannot change owner of object 'tectgb.backuplden' or one of its child objects because the new owner 'dbo' already has an object with the same name.
As far as I can see though, dbo does not own another object of this name. The only thing i managed to find was an entry for the table (backuplden) in sysindexes. The table id to which this index is apprently a part of is the actyal backuplden table. But if i go through the GUI, i don't see any index of this name appear under this table.... i tried deleting this entry from sysindexes (on a test server!) but i still get the same error.......
Any suggestions on how to proceed???
Thanks,
Div
I'm having a problem assigning ownership on a table to dbo. The database is owned by dbo, but for some reason one of the tables is owned by a windows user. When i try to assign ownership to dbo, i get the following error:
Cannot change owner of object 'tectgb.backuplden' or one of its child objects because the new owner 'dbo' already has an object with the same name.
As far as I can see though, dbo does not own another object of this name. The only thing i managed to find was an entry for the table (backuplden) in sysindexes. The table id to which this index is apprently a part of is the actyal backuplden table. But if i go through the GUI, i don't see any index of this name appear under this table.... i tried deleting this entry from sysindexes (on a test server!) but i still get the same error.......
Any suggestions on how to proceed???
Thanks,
Div
