I have manually deleted data from a subscriber replicated table, and broken replication.
So now data is building up in the publisher table, and not getting copied across.
The table has an identity column, and the error is "Cannot update identity column 'Id' "
I don't have permissions to view replication - the error was sent to me as a screenshot of replication monitor
The DBA expects me to fix this. So I assume its within my permission set, I can modify both publisher and subscriber tables, but I can't even open the replication menu items in SSMS - (error cannot access distribution database)
I think I have to synchronise the keys between the two tables.
If manually copy the missing rows from publisher to subscriber, with IDENTTIY_INSERT to ensure matching keys will this fix the issue?
Can anyone suggest a way