Transactional Replication - table does not have the identity property 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?
There is no need to add an identity column for no reason.

My guess is someone is issuing a SET IDENTITY_INSERT ON when there is no identity column in this table.

You need to check the code to make sure it is correct.