Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2013-03-08 : 06:50:17
|
| Dear Experts,If I add a new index on my replicated database table i.e my subscriber database,will it replicate the same change on publication also?? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-03-08 : 07:09:28
|
| No, it will not happen automatically simply because the table is a replicated table.From MSDN: How do I add or change indexes on publication and subscription databases?Indexes can be added at the Publisher or Subscribers with no special considerations for replication (be aware that indexes can affect performance). CREATE INDEX and ALTER INDEX are not replicated, so if you add or change an index at, for example, the Publisher, you must make the same addition or change at the Subscriber if you want it reflected there.http://technet.microsoft.com/en-us/library/ms151740.aspx |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-03-08 : 07:15:34
|
| Excellent info James.Thanks. |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-03-08 : 07:21:53
|
| You are very welcome - glad to help. |
|
|
|
|
|
|
Merge Replication Subscriber