CONSTRAINTS are gone at subscriber.

If all the articles are in the same publication, you can
gfet the replication setup to create the FK constraints
automatically. If not, you can use a post-snapshot
script. This'll have to be created manually and referred
to on the snapshot tab of the merge publication. If you
have already initialized, you can apply the script using
sp_addscriptexec.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
First I want to replicate all the lookup tables in a snapshot replication.
This will be done once (hopefully)
Second I want to replicate a merge publication of the three transaction
tables. This will be replicated continually.
I assume the post replication script on the merge publication will include
all the ALTER TABLE stmts, correct?
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:421801c523c2$527b7f60$a501280a@.phx.gbl...
> If all the articles are in the same publication, you can
> gfet the replication setup to create the FK constraints
> automatically. If not, you can use a post-snapshot
> script. This'll have to be created manually and referred
> to on the snapshot tab of the merge publication. If you
> have already initialized, you can apply the script using
> sp_addscriptexec.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Exactly!
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)