REPLICATION

DEAR ALL,

I SET UP A PUBLICATION SERVER (SQL 2005) AND A SUBSCRIPTION SERVER SQL2005 BOTH WITH SERVICE PACK. THE SETTINGS SEEM TO BE OK , AND I ALREADY SET THE TABLE WHICH I WANT TO REPLICATE. I AM USING THE TRANSACTIONAL MODE. AT THE BEGINING I COULD INSERT RECORD IN PUBLIC SERVER AND THERE WERE VISIBLE IN SUB SERVER. NEVERTHELESS WHEN I WAS TRYING TO INSERT IN THE TABLE FROM THE SUB SERVER I WAS NOT ABLE TO VIEW THE CHANGES IN PUBLISHER. ANY IDEAS PLS ?

MOREOVER, NOW I CAN NOT REPLICATE AT ALL. I DO NO KNOW IF I CHANGED ANYTHING, BUT I CAN NOT FIND IT. ANY HELP ON THIS PLS

THANKS IN ADVANCE FOR YOUR TIME

GREG

You need to use merge replication. With transactional replication you should not make changes on your subscriber - you should treat is as read only. Also check to see if your change on the subscriber has caused the distribution agent to fail.

You might want to switch to the continue on data consitency error profile to clear the problem.