Hi all

I have a database which contains 18 tables, 8 tables are owned by vishwas(owner) and rest of the tables are owned by dbo. now i want to change the owner of all the object(table). if i use sp_changeowner it does not work. if i use sp_changeobjectowner than i will lose the relationship among the tables.


thanks

pagal hai kya owner nai system change kar

Please confirm if u are a member of SysAdmin Fixed Server Role to change the ownership. To change the ownership, u should be a member of SysAdmin Fixed Server role.

Will try at my end also and get u updated.

B. Anant