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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy