Replication of a view with indexes

Question

Hi,

I`ve got a view which has two indexes. The view is replicated without
any  problems, only the two indexes are not replicated. Do I have to
setup it anywhere that indexes are replicated too?

THX

Answer 1

use a post snapshot command to do this.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 2

ok, and how do I do that?

Answer 3

on the properties of the publication under snapshot there is a section "run additional scripts" there you should put your script. or you could do it manualy at the subscriber

Answer 4

I hope this could be done by using sp_addartical

@schema_option =] schema_option
Is a bitmask of the schema generation option for the given article. schema_option is binary(8), and can be the | (Bitwise OR) product of one or more of these values:

Note: 
If this value is NULL, the system auto-generates a valid schema option for the article depending on other article properties. The Default Schema Options table given in the Remarks shows the value that will be chosen based upon the combination of the article type and the replication type.
 

Value  Description  
 
0x10  Generates a corresponding clustered index. Even if this option is not set, indexes related to primary keys and unique constraints are generated if they are already defined on a published table.

---

Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.