How to maintain IDENTITY property of a column on both publishing and subscribing databases in transactional replication?
If you maintain IDENTITY property on the subscribing table, distribution agent fails with the following error even after creating the publisher’s IDENTITY property with NOT FOR REPLICATION option: An explicit value for the identity column in table ‘t1’ can only be specified when a column list is used and IDENTITY_INSERT is ON. Category: Data source Source:
Related Questions
- What if the user employs several Enhanced Operator Stations as the primary operator interface? Will he still have multiple databases to maintain after migrating to Experion?
- Whose responsible to maintain driveway approaches between the street and private property?
- What is the benefit of subscribing to CCOHS databases?
