Saturday, February 25, 2012

Adding index to published table

Is this possible?
How would I do it?
Rob
Rob,
if it's just to exist on the publisher then you can just go ahead and add it
using EM or TSQL. This index won't be propagated to the subscriber, and even
in SQL 2005 with the option to replicate schema changes this is true. To be
sure to get the index to all subscribers, you can use sp_addscriptexec.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi,
So can I also manaully add /modify /drop the same indexes at the subscriber
using EM and T-SQL as well? Planning to do some major performance tuning in
my application soon.
TQ in advance.
"Paul Ibison" wrote:

> Rob,
> if it's just to exist on the publisher then you can just go ahead and add it
> using EM or TSQL. This index won't be propagated to the subscriber, and even
> in SQL 2005 with the option to replicate schema changes this is true. To be
> sure to get the index to all subscribers, you can use sp_addscriptexec.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Yes - index alterations are not seen as schema changes in that regard. The
same is true in SQL Server 2005 where there is the option of automatic
schema alterations being replicated - ie indexes aren't.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment