Post reply

No PKs on Replicated tables

  • October 6, 2003 at 9:00 am

    #83225

    Someone else posted a problem with getting rid of PKs and indexes on replicated tables.

    But I have the opposite problem, when I started Trans Repl, none of the PKs came over to the subscription database. Did I miss something in the properties of the publication or subscription that says to propagate the PKs ?? Same with indexes

    Any thoughts ?

    Edited by - homebrew01 on 10/06/2003 09:00:15 AM

  • October 8, 2003 at 10:16 am

    #477589

    Yes, you must select to create indexes on subscribers. With EM, in the publication properties and in the list of article, click in the button next to each article and in the last tab you can select it.

    Or if you are using a script, check the parameter schema_option in the sp_addArticle stored procedure.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply