Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Replication
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQL Server Replication
Miscellaneous
Thread ID:
00673865
Message ID:
00673865
Views:
50
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. 
Aubrey
Next
Reply
Map
View

Click here to load this message in the networking platform