It seems to me that you need transactional replication and not snapshot. Snapshot copies the entire content everytime, not very efficient way to do it. Transactional replication copies only "updated" data across so you won't have issues with create/delete table/index/constraint.

>Hi guys,
> Two branched or our currently connected through VPN 512kbps XDsl line. now what would be the best possible replication use . where Branch A contains live and we want to sycn it to branch B which branch B requires only for view and reporting. I use Snapshot replication
>but it seem an error occur when subcribing. Ive notice dat theres an erron creating and delete existing structure of Branch B every time I Sync. It seem that there is a Referencial Integrity error.
> my question is ,is replication works like this, when i change structure in Branch A, does it also change structure on branch B? or do i need to drop or Contraints before Sync? what primary Key field it requires? currenty i used only Int as my primay key
> tns