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] >-----Original Message-----
>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
>
>.
No.
[quoted text, click to view] >-----Original Message-----
>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.
>
>>-----Original Message-----
>>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
>>
>>.
>>
>.
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
Don't see what you're looking for? Try a search.