Post reply

Changing a Database Owner

  • July 25, 2002 at 2:56 am

    #58479

    I am trying to delete a user but cannot as he owns certain databases. How do I change the database owners??

  • July 25, 2002 at 3:15 am

    #433340

    Try this:

    sp_changedbowner

    -> Changes the owner of the current database.

    Syntax:

    sp_changedbowner [ @loginame = ] 'login'

    [ , [ @map = ] remap_alias_flag ]

    G,

    Nico

  • July 25, 2002 at 3:48 am

    #433341

    That worked fine.. Thanks very much.

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

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