Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    7

    Red face Unanswered: Replication error

    Hi

    I am trying to replicate a database using the snapshot method. The publication worked fine, when the second server tried to pull the replication, it started, but then come up with the following error whilst creating the tables.

    Insert Error: Column name or number of supplied values does not match table definition.

    Any ideas?

    cheers

    Simon

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

    Re: Replication error

    The error usually occurs in transactional replication when someone accidentally changed the DDL in subscriber. You can reinitialize the subscription from the publication database and refresh your subscription.

  3. #3
    Join Date
    Aug 2003
    Posts
    7

    Re: Replication error

    still no luck. Didn't help. Stil had the same error, any other ideas?

    cheers

Posting Permissions

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