sp_MSchangeobjectowner (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_MSchangeobjectowner(nvarchar @tablename
, nvarchar @dest_owner)

MetaData:

   
  
create procedure sys.sp_MSchangeobjectowner(  
    @tablename sysname,  
    @dest_owner    sysname  
)AS  
    declare @uid         smallint  
    declare @retcode    int  
      
    --  Security check  
    exec @retcode= sp_MSreplcheck_subscribe  
    if @@error <> 0 or @retcode <> 0  
    begin  
        raiserror(15247, 11, -1)  
        return (1)  
    end  
  
    select @uid=schema_id from sys.objects where name=@tablename  
  
    -- do not bother to call sp_changeobjectowner the object is owned by the @dest_owner itself  
    if SCHEMA_NAME(@uid)=@dest_owner  
        return(0)  
    exec @retcode=sys.sp_changeobjectowner @tablename, @dest_owner  
    if @@ERROR<>0 or @retcode<>0  
    begin  
        raiserror(21346, 16, -1, @tablename, @dest_owner)  
        return (1)  
    end  
    return(0)