Post reply

Changing the owner of the object

  • May 30, 2007 at 9:58 pm

    #178855

    Hi,

     

    I have to change the owner of an object to dbo. The process I'm following for it is

    sp_changeobjectowner , 'test','dbo'

    but I'm not able to do so and getting error

    Object test does not exist or is not a valid object for this operation.

    I'm logging in as SA and still getting this error. What is wrong that I'm doing.

  • May 31, 2007 at 7:28 am

    #709987

    Try as noted in BOL

    sp_changeobjectowner  'existing_owner.object','dbo'

    without the existing owner it is most likely looking for dbo.Test and not John.Test if say John where the owner.

Viewing 2 posts - 1 through 1 (of 1 total)

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