Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
buraktuf
Starting Member
13 Posts |
 Posted - 2009-02-27 : 13:30:53
|
| hi, i got a problem with the dynamic filter of a table. Assume that i got a publication named Rep1. In this publication i publish 10 tables some of which are filtered with dynamic values such as SELECT * FROM [System].[User] WHERE exists(select UserId from Crm.UserEmployee ,Crm.Employee where [user].ID=userID and UserEmployee.EmployeeID=Employee.Id and Employee.DealerId=(Select Id From Common.Dealer Where HostName=HOST_NAME()))but in the first synchronization it works for the subscriber and sends the appropriate filtered rows to the subscriber but then when the first synchronization finihes and it does not work for a newly added row which should be sent to the subscriber. This row does not be sent to the subscriber. what did i do wrong ? can there be any relation between this problem and data partitions or dynamic snapshot? or did i do wrong at anywhere else? can anybody help me. thanks for any reply. |
|
|
|
|
|
replication dynamic filter