PK Index owned by different user - how can I fix
Posted on 2006-10-31
I have an SQL 2000 database which is "managed" by a third party application. When we use the application to delete users, it automatically changes the ownership of any tables the deleted user owned to another user. I can only assume they use sp_changeowner through the backend - i haven't tried running a trace to confirm.
Somewhere along the lines I have two users that now own only the primary key on several tables. The tables themselves are owned by another user. Constraints are setup by the 3rd party app which prevent me from deleting and recreating the index, and I don't want to delete the whole table.
Can anyone suggest a way to change the ownership on the primary key index? I didn't realize it was even possible to have tables and indexes owned by different people for the same table.