mapping dbo to a different login name

• Tony-382973

  SSC Enthusiast

  Points: 154

  More actions

  June 24, 2009 at 12:38 pm

  #133382

  Hi,

  Under one of my databases user dbo has a login name domainA\UserX. I need to remap dbo to have a user called domainA\UserY. This is on SQL 2005 SP2 64bit. How can I do that?

  Thank you,

  T.

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  June 24, 2009 at 5:52 pm

  #1015003

  Run:

  sp_changedbowner 'domainA\UserY'

  under tht database.

  HTH!

  MJ