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 |
|
nejc
Starting Member
17 Posts |
 Posted - 2005-09-01 : 09:24:30
|
| hii have 2 merge replications set up, both connected to the same database on the same server (A->C and B->C). They both have exchangetye 2, so from publisher to subscriber only. When i was setting them up, i made only 1 condition in the filter (column1=1). After i tested the thing, i found out it have to add another condition to the filter - add "and column2=1". I did that in the publication properties, it accepted it with no problem. Then i ran the snapshot agent to reinitialize the replication, and i got an error 207 (Invalid column name 'columns2'...). The 2nd column DOES exsist. But now to the weird part...I deleted the "AND column2=1" from the filter, i retried to create a snapshot, but i still get the same error as before. It seems like the filter remained like it was there, but i am unable to see it. Whatever i add to the filter now (if i delete the whole condition, and replace it with a mikey the mouse, it would still say the same thing). I really dont want to drop the publication and do it all again.....so any ideas would be helpful. |
|
|
nejc
Starting Member
17 Posts |
Posted - 2005-09-02 : 08:21:10
|
| well, dropping the publication and reseting it worked. But i'm wondering why that happened on the first place ?i'm running sql server 2000 with sp3a |
 |
|
|
|
|
|
weird row filter error