SQL Server : Changing Object Ownership

Created 16 October 2003 00:00
For example, to change the owner of table MyTable to user MyUser, just run the predefined stored procedure sp_changeobjectowner:
  EXEC sp_changeobjectowner 'MyTable', 'MyUser'