Merge Replication and Dynamic Filters

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi.

I am developing an Windows Mobile 5.0 Application for the MotoQ. It
uses merge replication and everything works fine. The DB has a
dynamic filter on it so that it only sends the data that matches the
SUSER_SNAME(). The problem arises when a user, other than the inital
user for the program, wants to login using that device.

I want to have it drop the old subscription and start a new one with
the new user. I have coded it exactly as I want it, the thing is, it
still sends data for the first user. The only way for me to use the
program with a new, different, user is to reinstall it. I highly
doubt this is the only solution....


Any ideas are greatly welcome.

Thanks,
SmP

.

Relevant Pages

  • Re: how to send partial data to subscriber from publisher using .
    ... I am doing using replication and with dynamic filter and user defined ... "Chris Tacke, eMVP" wrote: ... >> I dont know much about RDA. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Replication dynamic filter on rowguid
    ... I have a lot of problems with dynamic filter on bidirectional MERGE ... replication if convert HOST_NAME on uniqueidentifier column that is ... the primary key (rowguidcol) of the table. ... central server sql server 2005 that have 1 merge publication for the ...
    (microsoft.public.sqlserver.replication)
  • Re: How to create .SDF file programmatically on the server for MR
    ... and then copy the resulting database file from there back to the ... It is completely easy in SQL Compact 3.5, as that runs on the PC directly, ... after a successful Merge Replication process against a SQL 2000 SP4 ... The size of the .SDF file is about 18MB and our Windows Mobile ...
    (microsoft.public.sqlserver.ce)
  • how to get host_name in .net programming for subscribers
    ... While setting up my merge replication through the replication wizard in I ... the host_name in sql server under dynamic filter for merge replication. ... I have 50 subscribers and 1 publisher. ... The publisher and distributer server name is ...
    (microsoft.public.sqlserver.replication)
  • How to tell which records are not syncd
    ... I'm creating a Windows Mobile 5.0 Smartphone program which ... uses SqlCeResultSets as its data objects. ... I use merge replication to sync the device with the host and I know ...
    (microsoft.public.sqlserver.replication)