create procedure sys.sp_help_log_shipping_monitor_primary
(
    @primary_server sysname
    ,@primary_database sysname
)
as
begin
    set nocount on
    declare @retcode int
    
    -- security check
    
    exec @retcode = sys.sp_MSlogshippingsysadmincheck
    if (@retcode != 0 or @@error != 0)
        return 1
    
    -- must be invoked from master db
    
    if (db_name() != N'master')
    begin
        raiserror(5001, 16,-1)
        return 1
    end
    
    -- return resultset
    
    select *
    from msdb.dbo.log_shipping_monitor_primary
    where primary_server = upper(@primary_server)
        and primary_database = @primary_database
    
    -- all done
    
    return 0
end