Update table names with owner

• sunshine-587009

  SSCrazy Eights

  Points: 8981

  More actions

  July 25, 2008 at 10:07 am

  #77053

  Hi,

  I'm looking to do the following but not sure which system table contains the owner name.

  Update owner.tablename to dbo.tablename_owner

  Ive got this...

  --Update sysobjects

  set sysobjects.name=sysobjects.name + sysusers.name

  where sysobjects.name<>1

  and then update to change all owners to dbo

  Any help appreciated!

  ¤ §unshine ¤

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  July 25, 2008 at 11:05 am

  #848599

  sp_changeobjectowner

  you would not update system tables.