Posted by DickChristoph on 10/02/54 11:46

Hi

I tried posting this query in microsoft.public.sqlserver.programming but got
no response.

I am new to replication but I am trying to setup up a transactional
replication of tables from one database to another in MSSQL 2000 (SP2).

My target tables have primary keys defined. Under publication properties I
go to the snapshot tab and for each table I clear the check box that says
"Drop the existing table and re-create-it" and "clustered Indexes." On this
page the nothing is checked. for each table.

Whenever the subscription is reinitialized it drops the primary keys on my
target tables
and replaces them with a unique clustered index on the column that used to
be
the Primary key.

Is this normal? Is there anyway to stop it from doing this?

I don't plan to send the snapshot more than once and let transactional
replication take over for keeping my source and target in sync, but if I
ever have to reinitialize the subscription, it would seem that I (or
someone) will
have to take the a second step of manually dropping these clustered indexes
and recreating the primary keys on the target table.

Thanks in advance.

--
-Dick Christoph



--
-Dick Christoph
dchristo@mn.rr.com
612-724-9282

• Next in forum: Re: Syntax Help!
• Prev in forum: Re: Converting Int value to datetime
• Thread view: Transactional Replication - Modifying Target Tables

[Reply to this message]