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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-08 : 07:24:26
|
| Gabriel writes "I'm learning replication (snapshot for now) and was trying filtering & got strange results. (SQL 2K sp2)Publisher: Table1FieldAFieldBFieldCSubscriber: Table1FieldAFieldBFieldCBut now, I decide after the fact to filter FieldC. The subscriber Table still has 3 fields, but the publisher data from Field 1 + 2 gets shifted across all 3 fields at the subscriber.If I manually drop the table at the subscriber, then next time the job runs, it recreates the table with just 2 fields and looks good.Is there some way to set replication so that it will drop & re-create the subscriber table automatically if the filter changes ? Or am I missing something else in my understanding ?Under "Default Table Article Properties - Snapshot" the option "DROP the existing table & recreate it" is checked. When does that apply ?? Just when first set up ?Any enlightenment is appreciated." |
|
|
|
|
|
Replication - Column filtering confusion