sp_getsubscription_status_hsnapshot (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_getsubscription_status_hsnapshot(nvarchar @publication
, nvarchar @article
, nvarchar @publisher)

MetaData:

   
--   
--  Name:      
--           sp_getsubscription_status_hsnapshot  
--             
--  Description:   
--           Specialized stored procedure for heterogeneous snapshot agent to  
--           determine subscription status.  
--     
--  Security:   
--           Agent  
--   
--           Result set:  Subscription status  
--         
--  Owner:     
--           sward   
  
create procedure sys.sp_getsubscription_status_hsnapshot  
(  
    @publication    sysname,  
    @article    sysname,  
    @publisher    sysname  
)  
AS  
BEGIN  
    DECLARE @cmd            nvarchar(4000)  
    DECLARE @retcode        int  
    DECLARE @publisher_type    sysname  
  
    SET @retcode = 0  
  
    EXEC @retcode = sys.sp_MSrepl_getpublisherinfo  
        @publisher = @publisher,  
        @publisher_type = @publisher_type OUTPUT,  
        @rpcheader = @cmd OUTPUT,  
        @skipSecurityCheck    = 1  
  
    IF @retcode <> 0  
        RETURN (@retcode)  
  
    --  This procedue is only to be used with heterogeneous publishers      
    IF @publisher_type = N'MSSQLSERVER'  
    BEGIN  
        RAISERROR (21659, 16, -1)  
        RETURN (1)  
    END  
  
    SET @publisher = UPPER(@publisher) COLLATE DATABASE_DEFAULT  
    set @cmd = @cmd + N'sys.sp_MSrepl_getsubscription_status_hsnapshot'  
      
    EXEC @retcode = @cmd  
        @publication,  
        @article,  
        @publisher  
  
    RETURN (@retcode)  
END