I have a one way transactional replication set up between two 2005 MS Sql servers. Recently I have started to receive the following message in the replication monitor from the subscriber:
Table 'dbo.tblname' does not have the identity property. Cannot perform SET operation. (Source: MSSQLServer, Error number: 8106)
Will adding the identity column to 'dbo.tblname' on the subscriber resolve this error or do I need to drop and re-add the subscription?