locked
Msg 15063, Level 16, State 1, Line 1 RRS feed

  • Question

  • Hi,

    I have a database named migrationdb and i want to change DBO user from this database to a different user but we are getting error mention below.

    Msg 15063, Level 16, State 1, Line 1

    The login already has an account under a different user name.

    So kindly, suggest how to change default DBO user from this database.

    Thanks.

     


    Asheesh pandey

    Wednesday, April 11, 2012 2:59 PM

Answers

  • Can u try to checn  and use

    ALTER AUTHORIZATION T-sql

    Syntax

    ALTER AUTHORIZATION
       ON [ <class_type>] entity_name
       TO { SCHEMA OWNER | principal_name }

    <class_type> ::=
        {
            OBJECT | ASSEMBLY | ASYMMETRIC KEY | CERTIFICATE
        | CONTRACT | TYPE | DATABASE | ENDPOINT | FULLTEXT CATALOG
            | FULLTEXT STOPLIST | MESSAGE TYPE | REMOTE SERVICE BINDING
           | ROLE | ROUTE | SCHEMA | SERVICE | SYMMETRIC KEY
            | XML SCHEMA COLLECTION
        }

    Link

    http://msdn.microsoft.com/en-us/library/ms187359(v=sql.100).aspx


    Rama Udaya.K ramaudaya.blogspot.com

    • Proposed as answer by Janos BerkeMVP Wednesday, April 11, 2012 3:29 PM
    • Marked as answer by KJian_ Wednesday, April 18, 2012 1:49 AM
    Wednesday, April 11, 2012 3:21 PM