Invalid column name

• David Gray-367412

  Say Hey Kid

  Points: 700

  More actions

  December 13, 2006 at 4:26 am

  #175194

  Hi,

  Got a SQL 2005 pull subscription failing with the following error when

  trying to create from initial snapshot.

  2006-12-12 10:47:54.125 Applied script 'vat_allocs_deleted_57.sch'

  2006-12-12 10:47:54.140 Applied script 'pay_lines_deleted_61.sch'

  2006-12-12 10:47:54.171 Agent message code 207. Invalid column name

  'name'.

  There are no columns called 'name' in this database and a search

  through all the scripts (.sch) files aslo does not find any columns

  called 'name'

  If I could track down which .sch is causing the failure I can run in

  query analyser to see exactly what is happening.

  The replication engine does not appear to apply the scripts in any

  obvious order.

  Anyone have any ideas how I can track down the source of this problem?

  The replication is timed snapshot from SQL2000 to SQL2005

  Thanks

  Dave

• December 18, 2006 at 8:00 am

  This was removed by the editor as SPAM

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 18, 2006 at 3:26 pm

  #678818

  Your coulumn name might have special characters or spaces in it...

  You can log errors to an output to get more details about this error.

  How to enable replication agents for logging to output files in SQL Server

  http://support.microsoft.com/Default.aspx?id=312292

   

  MohammedU
  Microsoft SQL Server MVP