Post reply

Change dbowner

  • August 11, 2020 at 1:37 pm

    #3778949

    Can we change the dbowner to system databses ? if yes how can we proceed?

  • August 11, 2020 at 1:40 pm

    #3778950

    in sql 2005/sql2008

  • August 12, 2020 at 12:26 pm

    #3779213

    Nope.

    System databases and system objects are managed by the system. That's it.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • August 12, 2020 at 1:57 pm

    #3779264

    ramyours2003 wrote:

    Can we change the dbowner to system databses ? if yes how can we proceed?

    First, see Grant's reply.

    Second, I have to ask... why would you want to/need to do such a thing?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 12, 2020 at 3:34 pm

    #3779311

    As we  renamed sa login to anothet name and want to change the dbowners of all databases  but later versions like 2o12 onwards  dbowner of sys databases are changed , may i know thereason ?

  • August 12, 2020 at 4:06 pm

    #3779315

    ramyours2003 wrote:

    As we  renamed sa login to anothet name and want to change the dbowners of all databases  but later versions like 2o12 onwards  dbowner of sys databases are changed , may i know thereason ?

    Is that a typo?  Do you mean that the dbowner of system database are NOT changed?  The answer to that question is as Grant has stated it.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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