User ID

• Nita Reddy

  SSCarpal Tunnel

  Points: 4182

  More actions

  February 24, 2005 at 12:23 pm

  #85255

  I copied database called mydb from development to production, but all the objects belongs to myuser and that userid is not in the production. How should I replace myuser objects to dbo?????

   

  for example a table called payroll its belong to

  myuser.payroll

   

  Thanks

  Nita

• achavez

  Old Hand

  Points: 359

  More actions

  February 24, 2005 at 12:37 pm

  #543999

  exec sp_changeobjectowner 'myuser.payroll', 'dbo'

   

  
  -------
  at us, very deafly, a most stares
  collosal hoax of clocks and calendars
  
  eecummings
  

• Nita Reddy

  SSCarpal Tunnel

  Points: 4182

  More actions

  February 24, 2005 at 12:46 pm

  #544004

  Thanks!

  I forgot to mention that I have 100 objects, how to do all this object at Once

  Nita

   

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  February 24, 2005 at 1:03 pm

  #544006

  I would research performing a loop with sysojects where the objects are "owned" by the non-existent userid.  This way you could set-up dynamic SQL ...

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• kknudson

  SSCarpal Tunnel

  Points: 4986

  More actions

  February 24, 2005 at 1:55 pm

  #544018

  Try This, it will build the results in the window of QA.

  You can then cut and paste and execute the results.

  SELECT '''EXEC SP_ChangeObjectOwner ''' + User_Name(uid) + '.' + name + ''', ''dbo''' FROM SysObjects WHERE xtype = 'P' AND User_Name(UID) <> 'dbo'

   

  Oh, change the xtype to whatever you need, p = SPs

  
  KlK

• Vidas Zabinskas

  Hall of Fame

  Points: 3258

  More actions

  February 24, 2005 at 11:51 pm

  #544068

  You can try to write your  objects cursor and then execute sp_changeobjectowner