Post reply

PK in transactional rep/

  • November 4, 2005 at 4:02 am

    #92009

    Hello!

    I read in one article that in transactional replication, a table must have a primary key to participate in rep/.

    Is that true?

    I don't remenber seeing this on BOL...

    Thankx

    Cláudia

    Regards,

    Cláudia Rego

    www.footballbesttips.com

  • November 4, 2005 at 5:22 am

    #602308

    It is in BOL: in the index, enter transactional replication and then select planning. About halfway down in the page will be:

    Primary Keys

    All published tables in transactional replication must contain a declared primary key. Existing tables can be prepared for publishing by adding a declared primary key using the Transact-SQL statement ALTER TABLE.

    SQL = Scarcely Qualifies as a Language

  • November 4, 2005 at 5:29 am

    #602312

    Ok!

    My table don't have PK.

    I will study alter table in order to add a pk

    thanks

    Cláudia

    Regards,

    Cláudia Rego

    www.footballbesttips.com

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

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