Changing Ownership of tables

• achowe

  SSCrazy

  Points: 2075

  More actions

  February 25, 2005 at 2:28 am

  #87654

  Hi guys

   

  Does anybody know how I can change the ownership of some tables to dbo without recreating them?

  All help appreciated

  Cheers

  
  If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

• achowe

  SSCrazy

  Points: 2075

  More actions

  February 25, 2005 at 2:34 am

  #544098

  panic over, I have used sp_changeobjectowner

  
  If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!