hello there,

currently i'm developing a mobile apps(pocketpc) with DB interaction either locally(sql server CE) or externally(sql server 2000). i intend to use sql server replication(merge replication) to synchronise both of them.

but my application is meant for multiple users. thus, i won't replicate data which is not belong to the user.

i found no other way to do this except by implementing dynamic filter(ex: SUSER_NAME).as a result, i'm having problem to access the publication with a new DB user but it was a success if i access using 'sa'.
can anybody help me ???

hopefully my words are understandable
kindly help

regards