Hi experts,

I am currently using SQL Server 2000. My system uses replication is
synchronize the data between HQ and the branches. Can SQL Server 2K support a
partial replication of the columns in a published table?

Partial replication means to replicate only some of the columns in a table
between HQ and branch, while leaving the non-replicated columns "localized".
E.g. in a Stock table, with columns [Price] and [Quantity], HQ controls the
price for all branches, while branch retains control of its own stock level.

I tried with "Filter Columns" but it only ended up removing the unchecked
columns in the subscriber, and I cannot add non-replicated columns into a
subscriber table used for replication.

Hi Paul,

Thanks, views with triggers really powerful stuff. New alternatives for
architectural design.

Now it got me thinking more of these questions:

1) While I suspect there will be some performance overhead using the
StockView case, but based on your experience, would there be a HUGE
performance overhead, or would it be within an acceptable range?

2) On a similar note, how would the performance acceptability be if I add
index to the StockView?

If performance overhead is acceptable, then the StockView would certainly
behave like a Stock table!

[quoted text, click to view]