YvonneTsang
Programmer
I am having a major problem with my identity column after I did a DTS import and a snapshot replication.
What occured was that I DTS'd a bunch of records into my table, restarted my snap shot agent to populate all of my changes, and validated my subscription. The Agent pushed my new snapshot over and since then things have gone wrong. When I try to insert a record into my subscription database I keep getting a PK error. The PK is an identity column and I am wondering if there is a way to allow me to get my Identity column value back to the proper value. When experiencing this problem before I just deselected identity, saved, reselected saved then everything was ok. I am unable to do this now because of replication. Can anyone help me?
Terry
What occured was that I DTS'd a bunch of records into my table, restarted my snap shot agent to populate all of my changes, and validated my subscription. The Agent pushed my new snapshot over and since then things have gone wrong. When I try to insert a record into my subscription database I keep getting a PK error. The PK is an identity column and I am wondering if there is a way to allow me to get my Identity column value back to the proper value. When experiencing this problem before I just deselected identity, saved, reselected saved then everything was ok. I am unable to do this now because of replication. Can anyone help me?
Terry