Using SQL SERVER 2005, I have a couple of questions on Replication and referential integrity.
1) Does Replication handle referential integrity?
2) If I do an Insert to Parent table and then to Insert to Child table, in one transaction, on Source DB - will Replicated DB also behave in the same manner? I.e. In Replicated DB record must be present in Master table, before it is referenced in child table?