sql server replication: Hi,
I'm trying to set up transactional replication between 2
servers running Win2k server, SQL Server 2000 SP 3. I'm
using a third server as Distributor, also with Win2k and
SQL Server 2000 SP3.

Everytime the distributor tries to push the initial
snapshot to the subscriber, I get this error message:

Insert Error: Column name or number of supplied values
does not match table definition.
(Source: Server1 (Data source); Error number: 213)

The thing is that the database in the subscriber is
empty, I'm using the option "initialize schema and data"
when creating the push subscription, so the schema is
created from the initial snapshot and the databases
should be identical.

Any ideas?

Thanks in advance

It almost sounds like a service pack on one of the servers did not get run
sorrectly. You can turn on Profiler at the publisher, subscriber and
distbutor and see if you cna catch where the error is occurring. That might
help narrow down what it could be.

Rand
This posting is provided "as is" with no warranties and confers no rights.