Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tjstirn
Starting Member
3 Posts |
 Posted - 2003-06-12 : 12:33:10
|
| Greetings,I've been struggling with an intermittent problem with one way replication to a failover system. Occasionally I will get an error stating:Cannot update identity column <column name>.(Source: <subscriber host> (Data source); Error number: 8102)Of course all identity columns are marked as not for replication. It is my understanding that this should never be a problem. Any idea as to why I am seeing this error?Thanks in advance,Tom |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-12 : 12:34:52
|
| I don't have the answer to your question, but I've got a question for you. Why are you using replication for your failover system? That is what log shipping is for.Tara |
 |
|
|
tjstirn
Starting Member
3 Posts |
Posted - 2003-06-12 : 12:41:12
|
quote:
I don't have the answer to your question, but I've got a question for you. Why are you using replication for your failover system? That is what log shipping is for.Tara
It is our intention to use the failover system for some read only decision support queries as well as the hot backup so we've implemented transactional replication to support it.Tom |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-12 : 12:45:22
|
| But log shipping allows you to put the failover system in read-only mode. So you would still be able to do your read-only queries.Tara |
|
|
|
|
|
|
Replication Problem - Update of identity columns