Changing table ownership

• Jeremiah Perez

  SSC Veteran

  Points: 213

  More actions

  January 3, 2007 at 10:53 am

  #62780

  Hi,

   

  Just like to ask if there is a way in changing a table's ownership. Ex. from TEMPOWNER to DBO.

   

  Thanks

• Adam Angelini

  SSCrazy Eights

  Points: 8548

  More actions

  January 3, 2007 at 12:35 pm

  #681022

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

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  January 4, 2007 at 10:01 am

  #681257

  Just don't forget to qualify the original object !

   

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

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

• paulrcyr

  SSC Enthusiast

  Points: 192

  More actions

  January 7, 2007 at 7:55 am

  #681675

  http://www.sqlservercentral.com/columnists/kKellenberger/understandingobjectownership.asp