Should We See Replication Filter Where Clause Text In Profiler TextData On SQL Server 2005?

 
We have Merge Replication publications for SQL Server 2005 Compact Edition subscribers.
Some articles have filter statements that send rows to multiple subscribers, based on the value of Host_Name() supplied at run-time.
 
Our publications work for most subscribers, but we have at least one subscriber who downloads too many rows from one of the filtered tables. 
 
When we run the Select SQL from the article's Filter statement it returns the intended 4 rows for this subscriber. 
We cut and pasted the filter statement into query analyzer, substituted the subscriber's value for Host_Name(), executed the statement, and got the proper 4 rows for this subscriber in the results.
 
But when this subscriber syncs her Compact Edition database it downloads 10 rows - the proper 4 rows that the filter statement should pass, plus 6 other rows that she should not download. 
Our hypothesis is that the Filter statement is not properly applied to the article when this subscriber syncs.
Other subscribers get the proper rows when they sync, so the publication's filter statement works in some cases, for some values of Host_Name().
 
We'd like to see the application of the filter statement at run-time (sync-time), but we have not found the text of the filter statement in SQL Profiler output.  Should we expect to see the text of the filter statement in SQL Profiler output?
Is there a better way to debug this error?
 
FYI, here's the text of the article filter statement:
 

SELECT <published_columns> FROM [dbo].[TBL_USER] WHERE user_sys_id in (

select u.user_sys_id

from tbl_user u

join tbl_territory t on u.territory_gid = t.territory_gid

where t.terr_no_id like (

select

case (select t.data_access_qnty from tbl_user u join tbl_territory t on u.territory_gid = t.territory_gid where u.user_sys_id = Host_Name())

when 2 then (select t.terr_no_id from tbl_user u join tbl_territory t on u.territory_gid = t.territory_gid where u.user_sys_id = Host_Name())

when 3 then (select left(t.terr_no_id,5)+'%' from tbl_user u join tbl_territory t on u.territory_gid = t.territory_gid where u.user_sys_id = Host_Name())

end

)

)
 
And here's the statement we ran from Query Analyzer:
 

declare @id varchar(10)

select @id = 'aultnc'

SELECT * FROM [dbo].[TBL_USER] WHERE user_sys_id in (

select u.user_sys_id

from tbl_user u

join tbl_territory t on u.territory_gid = t.territory_gid

where t.terr_no_id like (

select

case (select t.data_access_qnty from tbl_user u join tbl_territory t on u.territory_gid = t.territory_gid where u.user_sys_id = @id)

when 2 then (select t.terr_no_id from tbl_user u join tbl_territory t on u.territory_gid = t.territory_gid where u.user_sys_id = @id)

when 3 then (select left(t.terr_no_id,5)+'%' from tbl_user u join tbl_territory t on u.territory_gid = t.territory_gid where u.user_sys_id = @id)

end

)

)
 
Thanks

• Profiler TextData Truncation
• How Can The Profiler Textdata Field Be Enlarged?
• Profiler's TextData Column Has 'NULL' And Longest Durations
• Sql Replication Filter Clause
• Sql Profiler Creates Coulmn (TextData, Ntext, 16) While Saving Trace To Table , Could WE Make It Mo
• Profiler In SQL 2005 Filter On Host Name
• Profiler In SQL 2005 Filter On Host Name
• PDF Filter For MS SQL Server 2005 Full Text Search
• Profiler Filter
• SQl Profiler Filter
• SQL Server 2005 - Transactional Replication Involving Depricated Text And Ntext Data Types
• Where Clause Filter
• How To Include Variable In CURSOR SQL Filter Clause?
• Filter Criteria - Temp Table Join Or Where Clause?
• Sql Server 2005 Profiler
• Sql Server 2005 Profiler
• About The SQL Server Profiler 2005
• Errors In SQL Server 2005 Profiler
• SQL Server 2005 Profiler Error
• Profiler For SQL Server Express 2005
• Profiler In SQl Server 2005 Express Edition
• Profiler Trace With SSE 2005 (SQL Server Express)
• SQL Server 2005 - Filter For This Month Only
• Stmt Text From Profiler
• SQL Server 2005, Parameterized Filter: Snapshot Could Not Be Applied
• Replication With Filter
• Replication Filter Bug?
• SQL PROFILER: Creating Full Text Files For A Trace
• Setting Up Filter For RDA Replication
• How To Filter Condition While Transactional Replication
• Filter Records During Transactional Replication.
• Merge Replication And Filter Columns
• Row Filter Error In Snapshot Replication
• Merge Replication With Dynamic Filter
• Is This A Known SQL Server 2005 T-SQL Bug With Sub-selects In An IN Clause
• Filter Dost Not Work In Merge Replication
• Merge Replication Using A Guid As A Dynamic Filter
• SQL Server 2005 Is Rtrim Needed In Where Clause?
• Top Clause In SQL Server 2005 Compact Edition
• Merge Replication- Update To Filter Table Times Out
• SQL Server 2005 Performance - Where Clause Range Retriaval
• INSERT INTO OPENROWSET Does Not Respect ORDER BY Clause On SQL Server 2005 EE
• Null Values In TextData For Events 41 And 42 Using Fn_trace_gettable
• Full Text Search Indexing HTML - Does The Filter Expect Certain Tags To Be Present As Standard?
• Full Text Search Indexing HTML - Does The Filter Expect Certain Tags To Be Present As Standard?
• Disappearing Parameterised Filters And Filter Joins In Publication Properties Page Of Replication Monitor
• Dynamic Table & Contains Clause For Full Text Searches