BUENOS DIAS, TENGO UN PROBLEMA. TENGO UN SERVIDOR WIN 2003 EE, Y Microsoft SQL Server 2005 - Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) , TENGO 11 EQUIPOS WINXP SP2 Y TENGO EL SIGUIENTE MENSAJE: No pudo aplicarse en el destino el cambio de la fila con el sobrenombre de artículo 52765001...

Here is the article I like about SQL replication. http://www.sql-server-performance.com/articles/dba/sql_server_2005_replication_gui_p1.aspx

Hi, If you need to replicate those data only for reporting purpose snapshot replciation will do(low latency) , else you can go with transactional replication. If your requirement is something that wants Offshore data to be merge with your US - OLTP database and vice versa then go for merge replication...