We can set ansi_nulls off then use <> ,=

Thank you for your question.It's a good point that I had never attended.It's obvious in question that 10000 rows are inserted without transaction because the records are inserting through...

Dear Pradeep

I want to separate updating data on each server so that some data will updated on one server and some on another for avoiding conflicts, but it seems that...

Thanks. I'm going to read about peer to peer.

Dera Tejas Shah

Thank you for your reply,Your solution is very good and practical.This is exactly what I need

With many thanks to other replies

Hi

All of filenames and paths are correct.This error occure befor restoring database when

i want to add two backup device to grid.

 thanks

Thanks  all for involving.i check tables on publicationt database and see there was MS_merge disable triggers in all table that didn't let any update perform on table.when i removed them...

i don't want  change the table structure but when i want  to update ,insert or delete any row in replicated tables at publicated server, sql server  show me that message.

Dear Thomas you'r method is very technical and beutifull.I am waiting to hear further subjects from you