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