October 17, 2002 at 6:47 am
Sql 7
I have a trigger which fires when a shipment occurs, a sp writes to a table, this table is replicated to a table with the same name in another database.
The table receiving the replication, has an insert trigger which executes a sp to submit records to a dataq.
My problem is this, when the dtaq is being loaded, writes to the dtaq are by order #, then I want to delete records in the table that was replicated by order #, but I keep getting an error message stating that duplicate records cannot be added to the dtaq. I don't know how I could clean up the original table without deleting records as I am processing them into the dtaq. I can't do a straight delete, I could delete something that wasn't replicated yet. I hope this makes sense....Any ideas?
October 17, 2002 at 7:23 am
Not sure Im clear on this, but a first try - why not just tag as deleted and then periodically clean them up?
Andy
October 17, 2002 at 7:50 am
Thank You for your response Andy, I apologize for submitting this to the performance tuning Forum.
I went to the replication forum and found your article, so this made my problem clearer.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply