Post reply

changing owner of database in MS SQL

  • October 1, 2008 at 12:28 am

    #73048

    I have imported .mdb file into MS SQLServer

    I can found all my tables in MSSQL but with dbo owner

    Now i want to change the owner of my database to td

    so is there any way to change owner of database from DBO to TD?

    if anybody have solution for this please provide

    I would be very thankful to you.

    Thanks in advance,

    Rajesh Gottapu

  • October 1, 2008 at 9:42 am

    #879577

    What you want to do is change the login mapped to dbo in the database. Use sp_changedbowner to do that in the current database:

    sp_changedbowner 'td'

    Note: td cannot be a user in the database. If it already has access to the database, drop it before running the sp.

    Greg

  • May 18, 2009 at 1:38 pm

    #996594

    I have the exact opposite situation. I have a database where all tables are owned by, let's say for this example, 'td'. I would like to change the owner to 'dbo'. When I try:

    sp_changedbowner 'dbo'

    it returns the message that the login 'dbo' does not exist.

    Any suggestions?

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

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