Alter Table Owner

• Express12

  SSCoach

  Points: 18514

  More actions

  December 1, 2005 at 8:34 am

  #102964

  Is it possible to alter the OWNER of a table in SQL Server 2000?

  2 tables were replicated --- then a script was executed by another DBA that set the OWNER of the tables to DBO.  Access to the tables worked yesterday (as DBO) but today the OWNER is set to replication_user --- and access to these tables is no longer working.

   

  BT

• Tim Januario

  SSChasing Mays

  Points: 609

  More actions

  December 1, 2005 at 9:20 am

  #607094

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

  (check BOL for more details).

  I'm not sure how that will work with replication however.

  Tim Januario