Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cell_josh
Starting Member
2 Posts |
 Posted - 2006-03-15 : 10:51:52
|
| Hi,I am trying to set up replication between 2 sql 2000 servers. I have configured the distributor, Publisher and supplier. on the supplier i created a new blank DB. When i try to PUSH the initial snapshot, all the tables and stored procs get built (so it seems) then i get the following error:Insert Error: Column name or number of supplied values does not match table definition.Seems the data is not getting copied but i cannot find how i see which command raises the error. does anyone know how i can find this out, or has anyone seen this error at this stage. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-16 : 08:13:31
|
| yeah, go to your snapshot agent and look at the error details, you should be able to find the problem in there.. Is the user you are using to set replication up (or your sql agent service) a domain account with admin rights to both servers? |
 |
|
|
|
|
|
error during initial snapshot push