sql server replication: What does replicating UDFs, views and indexed views buy us if the subscriber
is gonna be used for read only ?
And even if the subscriber was used for applying inserts,deletes and updates
but had created them manually on the subscriber, what addition does
replicating them buy ?

I am using SQL 2000

Replication of UDFs and Views transfers nothing but scripts to the
subscriber, so that you could use those UDFs and Views on the subscriber for
querying the subscribed data.

However, replicating Indexed views has some interesting uses. For example,
you have two tables on the publisher, but you want a combination of these
two tables, based on a join, to be replicated to the subscriber. In this
case, you could create an indexed view and replicate it, instead of
replicating those two tables.

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




[quoted text, click to view]
What does replicating UDFs, views and indexed views buy us if the subscriber
is gonna be used for read only ?
And even if the subscriber was used for applying inserts,deletes and updates
but had created them manually on the subscriber, what addition does
replicating them buy ?

I am using SQL 2000