Sql server 2k , Replication issue (Insert Err

• spaliwal

  SSChasing Mays

  Points: 604

  More actions

  September 11, 2003 at 12:32 am

  #82425

  Hi Gurus,

  Environment Sql server 2000 sp3 , Win 2000 box.

  I am trying snapshot replication on same box. I mean my distributor is same

  m/c , Publisher and subscriber database are also on the same server.

  While initilizing / reinitilizing i am getting the following error.

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

  I am using Push type of replication and subscriber database i am creating blank at the time of replication setup. Also i am sure that there is no structure change or any other activity is going on since its a test server and i am the only user.

  while searching i found it was a bug in sql server 7.0. I am not in 7.0 but

  2000.Following is the bug url -

  http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q250/6/23.asp&NoWebContent=1

  TIA,

  Sheilesh

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 15, 2003 at 1:45 pm

  #474240

  Do you have the snapshot configured to drop/create the schema each time?

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn