Hi All,

I am going to implement 1 publisher with multiple subsriber model in transactional replication. I use push subscription option. While i replicate the data i want to define the order of flow of data between various tables.For example, the following tables are included in publication and i want the order of data flow as follows,

1. Dept ( This is table with Dept_ID as primary key)
2. Employees ( This table has DeptID as foreign key)
So, i want to make sure that all Dept datas are replicated before replicating the Employee tabble records.

Any inputs would be of much help...