Executing a system SP through a loop

• Carl Rimmer

  SSCarpal Tunnel

  Points: 4068

  More actions

  April 4, 2006 at 5:22 am

  #152883

  I am looking for a solution to changing the owner of multiple objects within a database from one owner to another.

  I want to use the system sp (sp_changeobjectowner ) to change the owner of the tables from A to B.

  Does anybody know of a script to automate this task? otherwise I will have to copy the command and paste it multiple times changing the name of the object.

   

  Any help would be appreciated.

   

  Regards

   

  Carl

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  April 4, 2006 at 6:07 am

  #630624

  Carl - if you search this site you're bound to find (at least) several posts with questions similar to yours...

  I found one such for you where several members have submitted their solutions - take your pick..

  change objectowner

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• Carl Rimmer

  SSCarpal Tunnel

  Points: 4068

  More actions

  April 4, 2006 at 8:42 am

  #630682

  Thanks.

   

  I ended up using the sp_change_users_login to resolve the orphaned user on the new server rather than dropping the user and recreating.

   

  Thanks Anyway.

   

  Carl