I have setup transaction replication with a non-updating subscriber. The update commands on the publisher are turning up as delete and insert at the subscriber. This is can not happen on in this scheme. What's wrong? Siva
Are you able to script out the replication and post: the sp_addpublication command the sp_addarticle command for your problem table the sp_addsubscriber command Cheers Twan
This may help. INF: UPDATE Statements May be Replicated as DELETE/INSERT Pairs Microsoft Knowledge Base Article - 238254 http://support.microsoft.com/defaul...s/q238/2/54.asp&NoWebContent=1&NoWebContent=1