all groups > sql server replication > august 2003 >
You're in the

sql server replication

group:

indexes not replicated...


indexes not replicated... Rob
8/13/2003 11:53:50 AM
sql server replication:
Using transactional replication, create and drop index
commands do not get replicated. Is this normal
RE: indexes not replicated... Rob
8/13/2003 2:06:56 PM
But that option is only available with snapshot
replication.

Is there a way to have the indexes, dropped and/or created
on the publisher, replicated over to the subscriber, using
transactional replication?

Thanks for your response.

[quoted text, click to view]
RE: indexes not replicated... chris
8/13/2003 3:08:51 PM
No.

[quoted text, click to view]
RE: indexes not replicated... gopal NO[at]SPAM online.microsoft.net
8/13/2003 8:58:07 PM
In SQL Server 2000 we do propogate non-clustered indexes and clustered
indexes. you can check the option in the article properties, Are you not
seeing the index getting
created on the subscriber. Check the .dri file on the snapshot folder once
the snapshot agent has
run to check to see if the create index statements are there.

Gopal
Microsoft
AddThis Social Bookmark Button