Error updating replicated tables

thetallbloke

Hi Guys,

I have a Dynamics NAV 2009 installation using a SQL Server 2008 database. I have a number of tables in this database being replicated out to another database and then from there replicated out to other mobile databases using HTTPS, etc...

This all works great.. change the data in Nav using the classic or RTC, and the data flows out to all the replicated databases.

My problem arises when I try to modify a table throught classic client. I tried adding a new field to one of my tables that is being replicated using the table designer.. When I try to save and compile, I get the following error message:



I did a test to see if I could modify a repliated table using the SQL Management Studio and SQL Server is more than happy for me to modify a replicated table. It only seems to be Nav that spits about it.

Has anyone seen this before and know how to get around it...????

I'm happy to consider any of the following options:
1) Modify my publication to get around it
2) Beat Nav into submission so that it doesn't have this issue

I can't get rid of the replication.

This is quite a major issue for us as when we upgrade our client's sites and try to import objects that touch replicated tables, we get the error.

Any suggestions would be greatly appreciated..

Thanks

matttrax

I've seen this post a few times over the past month or so, although I can't remember if it's on here or DynamicsUser. Search both and you should find the answer.