changing a table''s owner

• coenzyme77

  SSCommitted

  Points: 1669

  More actions

  February 26, 2007 at 11:36 am

  #76665

  Hi everyone,

       Is it possible to change the owner of a DB table from the

       creater (the person who created the table) to dbo? If so how?

      Thanks for everyone being there to help.

      SQL 2000, SP4

     

• Chuck Rivel

  SSCrazy

  Points: 2991

  More actions

  February 26, 2007 at 11:42 am

  #691842

  sure, use the sp_changeobjectowner sp:

  EXEC sp_changeobjectowner 'table_name', 'dbo'