Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187

    Unanswered: Replication Question

    Hi all,
    I am seting up a Publisher in SQL 2000.
    When I get to the screen to specify Articles after selecting a transactional replication, most of my tables are unselectable. In fact out of 25 tables only one is selectable. The rest have a key with an x next to them. Why would that be?

  2. #2
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    Hi again,
    I went ahead and started a replication as merge replication. But now when I created a Pull Subscriber, the job failed with the following:

    Category:NULL
    Source: Merge Replication Provider
    Number: -2147201001
    Message: The schema script '\\NJRARSVR00E9\d$\sqldata\system\MSSQL$P001\ReplD ata\unc\NJRARSVR00E9$P001_PTR_PTR Merge\20040106110922\tblUser_1.sch' could not be propagated to the subscriber.

    What does this mean???

  3. #3
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Replication Question

    Do you have a primary key for each of those 25 tables?

  4. #4
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    I do not. I have a primary key on some, but not all.

  5. #5
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    You can't do transactional replication on tables tat do not have primary keys.

    Try adding primary keys into your table again before doing it.
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •