change the onwer of a database

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  January 4, 2005 at 9:26 am

  #163410

  Hi,

  I want to change the owner of a table. I want to change it to dbo. Please let me know how to do it.

  Thanks,

  Sridhar!!

• Osoba

  SSCommitted

  Points: 1964

  More actions

  January 4, 2005 at 9:44 am

  #535801

  sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'

   

  hope this helps.

• Adnan Maqbool

  Newbie

  Points: 1

  More actions

  January 4, 2005 at 1:53 pm

  #535859

  You can also go the design of the table and then table and index properties from thier you can select the owner of your own.

• Steve DiDomenico-197994

  SSChasing Mays

  Points: 638

  More actions

  January 4, 2005 at 2:00 pm

  #535861

  Thanks Osoba,

  This is exactly what I needed today.

  Steve