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 |
|
0341
Starting Member
21 Posts |
 Posted - 2007-08-21 : 14:27:37
|
| Is there a replication stored procedure that determines whether a replicated command should be treated as an insert, update or delete?ThxPhil |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-21 : 23:11:12
|
| That tells by command itself. Why do you need that? |
 |
|
|
0341
Starting Member
21 Posts |
Posted - 2007-08-23 : 08:18:42
|
| When I update a table on the publisher replication is trying to do an insert on the subscriber thus causing a key violation in the subscriber table. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-23 : 23:48:22
|
| You'll get that error if updated value exists in subscriber already. What kind of replication do you use? |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-24 : 00:53:42
|
| What is the error message?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
0341
Starting Member
21 Posts |
Posted - 2007-08-24 : 08:08:58
|
| I use transactional replicationThe error message is as follows "Cannot insert duplicate key row in object 'My_table' with unique index 'My_key'." |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-25 : 00:06:49
|
| Double check table on subscriber and clean it up manually. Is subscriber read only? |
|
|
|
|
|
|
REPL Stored Procedure