hello all,

I created a view and I want the result set(records) of the view to be
replicated to another server. i've tried replicating the view by checking the
view in the replication wizard but it seems that only the definition of the
view is being replicated. Is there a way that i can fullfill the desired
result through replication. That to store the result of the view to a new
table in the replication destination. I'm using snapshot replication

thanks in advance



joey

Jopey,
you can replicate this as an indexed view.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)