create procedure sys.sp_MSget_dynamic_filtering_information (
        @pubid uniqueidentifier,
        @uses_host_name bit output,
        @uses_suser_sname bit output )
AS
begin

    if exists (select name from dbo.sysmergepublications
                where pubid = @pubid and UPPER(dynamic_filters_function_list) like '%HOST_NAME()%'
                and sys.fn_MSisfilteredcolumn(UPPER(REPLACE(REPLACE(REPLACE(REPLACE(dynamic_filters_function_list, char(0x20),''), char(0x09),''), char(0x0D),''), char(0x0A),'')), 'HOST_NAME', NULL) = 1)
        select @uses_host_name = 1
    else
        select @uses_host_name = 0

    if exists (select name from dbo.sysmergepublications
                where pubid = @pubid and UPPER(dynamic_filters_function_list) like '%SUSER_SNAME()%'
                and sys.fn_MSisfilteredcolumn(UPPER(REPLACE(REPLACE(REPLACE(REPLACE(dynamic_filters_function_list, char(0x20),''), char(0x09),''), char(0x0D),''), char(0x0A),'')), 'SUSER_SNAME', NULL) = 1)
        select @uses_suser_sname = 1
    else
        select @uses_suser_sname = 0


    return 0
end