LOGIN Problem with Dbo

• Schalk van der Merwe

  SSC Veteran

  Points: 254

  More actions

  December 7, 2005 at 12:15 am

  #88829

  Hi guys;

  I only get this problem on one server; if I restore the database, the loginname that is the owner of all the objects has been assigned to the dbo username.

  If I go to Enterprise Man. - database - users - the login name says dbo and its login name is <my owner>

  how can i change this so that dbo and <my owner> is seperate? i want <my owner> to reflect as username <my owner> loginname <my owner>. Not with dbo????

  any ideas?

  

• David.Poole

  SSC Guru

  Points: 76039

  More actions

  December 7, 2005 at 1:57 am

  #608122

  exec sp_changedbowner '<>'

  LinkedIn Profile