Post reply

Unable to change object owner

  • December 11, 2008 at 10:55 pm

    #97018

    Hi

    In my db I am having 2 tables with name x.

    one table x owner is a and other is dbo.now i changed the name of a.x to a.x_old.

    now i executed sp_changeobjectowner 'a.x_old',dbo.

    I got the error.

    Server: Msg 15505, Level 16, State 1, Procedure sp_changeobjectowner, Line 63

    Cannot change owner of object 'citidocsdba.NG_D32_INDEX_TABLE_old' or one of its child objects because the new owner 'dbo' already has an object with the same name.

    pls help

  • December 12, 2008 at 12:07 am

    #911479

    The error message is self-explanatory. The new owner already has an object with the same name. in your case there is already an object x_old owned by dbo.


    Pradeep Singh

  • December 12, 2008 at 12:14 am

    #911480

    No there is no table with that name with dbo I checked.

  • December 12, 2008 at 1:02 am

    #911496

    can u run this query and let us know the results..

    select name, xtype from sysobjects where name='x_old'


    Pradeep Singh

  • December 12, 2008 at 9:07 am

    #911694

    are there indexs or triggers on the tables? you might need to change the name of them aswell?

  • December 19, 2008 at 3:31 am

    #915080

    Thanks.

    I got the solution

  • December 19, 2008 at 3:36 am

    #915081

    great!! Can u share what u did?


    Pradeep Singh

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply