Post reply

sp_changeobjectowner does not work?

  • July 6, 2004 at 12:47 am

    #83297

    I'm trying to change ownership of a few usertables. In QA I use sp_changeobjectowner 'tablename','sa' to change the user to dbo. I am loged in as sa. I receive the following message:

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

    This can happen once, twice, but even after copying the tablename in EM and pasting it in QA I receive this message. I an in the db with the tables to be changed.

    What is wrong here?

    Greetz,
    Hans Brouwer

  • July 6, 2004 at 1:01 am

    #513401

    Right, found out I had to qualify the reference to the table as 'owner.tablename'. The description in BOL did not make that clear to me, being loged in as SA I thought I was God...

    Greetz,
    Hans Brouwer

  • July 6, 2004 at 1:58 am

    #513410

    The same table name can be used to create tables for different owners, that's why you need to specify which table of which user you want to change...

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

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