Replicating a view on Sql server 2000 EE

[cyno]

Hello all - Are there any disadvantages using a view in transactional replication. I am using Sql server 2000 enterprise edition and the objects being referenced by view already exists on the subscriber.

Are there any steps consider before adding a view to the publication.

Regards,
Cyno

 

[mrdenny]

All adding the view will do is repicate the design of the VIEW to the other system. Data won't be replicated accross the view. If all the objects already exist on the subscriber then there should be no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com