By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,092 Members | 1,597 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,092 IT Pros & Developers. It's quick & easy.

Transactional Replication - Modifying Target Tables

P: n/a
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
dc******@mn.rr.com
612-724-9282
May 2 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
DickChristoph (dc********@yahoo.com) writes:
I tried posting this query in microsoft.public.sqlserver.programming but
got no response.
Did you try microsoft.public.sqlserver.replication? That's where the
replication wiz people hang out.
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).


SP2?

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 2 '06 #2

P: n/a
Thanks Erland, I didn't know there was such a group. I'll go there now.

Yes SP2. Thats what I have I my home machine from an old MSDN Universal
subscription. But the problem is also happening where I just started
working. I assume they are more current although they are on SQL 2000.

--
-Dick Christoph
"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...
DickChristoph (dc********@yahoo.com) writes:
I tried posting this query in microsoft.public.sqlserver.programming but
got no response.


Did you try microsoft.public.sqlserver.replication? That's where the
replication wiz people hang out.
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).


SP2?

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

May 2 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.