November 6, 2007 at 10:36 am
We have repl set up for a small group of tables. The whole process seems to work fine except for the following issues:
We have an ID field on one of the tables at the publisher set as an identity field but when it copies to the subscribers the identity attribute does not copy over.
For all tables we have msrepl_tran_version field which should have a default value of newID(). At the publisher 3 of the tables have this but a new table does not. At the subscribers the existing tables have the field but no default value and the new table has neither.
We have other pub/subs set up on for other db's and the process works fine so I wonder if it might be something specific with this set of tables? Any suggestions?
November 7, 2007 at 10:17 pm
This article discusses three common problems DBAs are likely to encounter when columns have the identity property,...
http://www.simple-talk.com/sql/database-administration/the-identity-crisis-in-replication/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply