locked
Replication of a view with indexes RRS feed

  • 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
    Monday, March 15, 2010 10:13 AM

All replies

  • 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
    Monday, March 15, 2010 1:42 PM
    Answerer
  • ok, and how do I do that?
    Tuesday, March 16, 2010 9:24 AM
  • 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
    Saturday, April 17, 2010 12:11 AM
  • 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.
    Sunday, April 18, 2010 9:04 PM