sp_MSsubscriptionvalidated (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_MSsubscriptionvalidated(uniqueidentifier @subid
, uniqueidentifier @pubid
, bit @log_attempt)

MetaData:

   
create procedure sys.sp_MSsubscriptionvalidated  
    @subid      uniqueidentifier,  
    @pubid      uniqueidentifier,  
    @log_attempt bit = 0  
as  
    declare @now datetime  
    declare @retcode int  
  
    select @now=getdate()  
      
    if ({fn ISPALUSER(@pubid)} <> 1)  
    begin  
        if (@pubid is NULL)  
        begin  
                RAISERROR (21723, 16, -1, 'sp_MSsubscriptionvalidated')  
                return 1  
        end  
        else  
        begin  
                RAISERROR (14126, 11, -1)  
                return 1  
        end  
    end  
  
    if @log_attempt=0  
        update dbo.sysmergesubscriptions set last_validated = @now, attempted_validate=@now  
            where subid = @subid and pubid = @pubid  
    else  
        update dbo.sysmergesubscriptions set attempted_validate = @now  
            where subid = @subid and pubid = @pubid       
    if @@rowcount <> 1 or @@error <> 0  
    begin  
        RAISERROR (20070, 16, -1)  
        return (1)  
    end  
    return (0)