InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 10:13:09 GMT20http://www.sqlservercentral.com/Forums/Topic1069450-2571-1.aspxDepending on how you've gutted the old solution: Could be trying to insert into NewCol that doesn't exist as yet (hasn't been initialised).Carlton.Fri, 25 Feb 2011 05:34:47 GMTCarlton Leachhttp://www.sqlservercentral.com/Forums/Topic1069450-2571-1.aspxI am using the SQL Azure Data Sync at https://datasync.sqlazurelabs.com to sync a table between 2 Azure databases on different servers. The initial sync is working fine but I need to re-create due to the addition of a new column.I have deleted the sync group, tracking tabkle, triggers and sync stored procedures in the hub database. When I create a new sync group I am getting an error Invalid column name 'newCol'. This is a sync to a new empty database so I guess the problem is some left over metadata somewhere in the hub (or master) database?Any ideas how to solve this issue or how to re-create a sync when adding new columns?ThanksFri, 25 Feb 2011 01:51:38 GMTDB Dan