sp_MSexecwithlsnoutput (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_MSexecwithlsnoutput(nvarchar @command)

MetaData:

 create procedure sys.sp_MSexecwithlsnoutput  
(  
    @command    nvarchar(max),  
    @xact_seqno    varbinary(16) output  
)  
as  
begin  
    declare @retcode int  
  
    select @xact_seqno = 0x0  
      
    --  security check for subscriber  
    --  Though the work below is related to a publisher, we use   
    --  a check for the subscriber because this is normally executed  
    --  by the distribution agent at a subscriber (republisher).  
    --  this should only be used by peer to peer subscribers.  
    exec @retcode = sys.sp_MSreplcheck_subscribe   
    if @@error <> 0 or @retcode <> 0   
    begin  
        return 1  
    end  
  
    begin transaction tran_sp_MSexecwithlsnoutput  
    save transaction tran_sp_MSexecwithlsnoutput  
  
    exec(@command)  
    if @@error <> 0  
    begin  
        goto FAILURE  
    end  
  
    --  if this is not a republisher we will get an error. this is expected  
    --  since we should never be calling this on a non-publisher database.  
    exec @retcode = sys.sp_replincrementlsn @xact_seqno = @xact_seqno output  
    if @@error <> 0 or @retcode <> 0   
    begin  
        goto FAILURE  
    end  
  
    commit transaction tran_sp_MSexecwithlsnoutput  
      
    return 0  
FAILURE:  
    rollback transaction tran_sp_MSexecwithlsnoutput  
    commit transaction  
  
    return 1  
end