Post reply

Changing the DB owner to dbo.

  • May 12, 2010 at 9:21 am

    #386914

    Hello,

    I came across an article on this site a while ago, which explained that its a good idea to change the owner of your databases objects to 'dbo', so I gave it a try and got the following error...

    cannot find the principal 'dbo' because it does not exist or you do not have permission

    So did a google, which gave similar messages for different situations, but not for a straightforward database owner change, I wondered if anyone could point me in the right direction?

    Thank you,

    D.

  • May 13, 2010 at 12:17 am

    #1166650

    Check your permissions.

    Check any logins is with username as dbo

  • May 13, 2010 at 12:38 am

    #1166654

    Hello,

    No there is no login as dbo, I should have checked this beforehand. Do I create one the same way as any other user and issue it sysadmin privs?

    Regards,

    D.

  • May 13, 2010 at 12:41 am

    #1166655

    First let me know who created the database

  • May 13, 2010 at 12:43 am

    #1166656

    Thanks for getting back, currently its the local admin account.

  • May 13, 2010 at 12:52 am

    #1166659

    then change the default schema to dbo

  • May 15, 2010 at 5:33 pm

    #1167969

    The database's owner should actually be the SA account not dbo. To change the database owner use the following statement:

    USE <DatabaseName>

    exec sp_changedbowner @loginame = 'sa'

    GO

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

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