Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server Replication
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00673865
Message ID:
00673959
Vues:
14
Reposted for readability.
************************************************
I implementated a SQL Server 2000 database for use by a VFP application I wrote. I want to use transactional replication keeping a live backup of the database running. I configured the main server to be the distributor and created the publication just fine. I then create a push subscription to the client just fine.

Some of the tables use identity columns marked at "Not FOR REPLICATION" per the SQL documentation. Some tables use GUIDs. When replication begins I receive an error 8102 "Cannot update identity column ." from distribution agent in SQL. My reading of the SQL doucmentation was that identity columns could be updated by replication. Any ideas why it won't update the identity columns?

Details are listed below.

Details:
The distribution agent calls stored procedure it creates for deleting, inserting and updating tables which it creates during replication setup. The stored procedure sp_MSupd<tablename> is passed a value for every field in the record. It receives NULL values for fields that didn't change in the main database for a given record update. This stored procedure is failing.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform