Warning: Undefined array key "HTTP_REFERER" in /www/wwwroot/prod/www.enjoyasp.net/wp-content/plugins/google-highlight/google-hilite.php on line 58

1，什么是合并复制。
将多个节点的数据变化合并起来同步到多个节点，保证节点数据一致。
在同步表中增加字段rowguid标识更改的行ID，在表增加触发器，插入更新存rowguid入到MSmerge_contents表内，删除存放在MSmerge_tombstone表内,
引用：http://searchsqlserver.techtarget.com/tip/How-merge-replication-works-in-SQL-Server
2，合并复制如何操作。

http://www.codeproject.com/Articles/28951/SQL-Server-2005-Merge-Replication-Step-by-Step-Pro

3，合并复制相关表。

http://blogs.msdn.com/b/repltalk/archive/2010/02/23/collection-of-merge-replication-best-practices.aspx

书籍：pro sqlserver2005 replication

http://books.google.com.hk/books?id=aup_ppJfgMcC&printsec=frontcover#v=onepage&q&f=false

4，查询没有复制分发的表
SELECT type_desc,name
FROM sys.objects
WHERE name NOT IN(
    SELECT name
    FROM sysmergearticles)
AND CHARINDEX('MS',name)<=0
AND CHARINDEX('sys',name)<=0
AND CHARINDEX('_',name)<=0
AND type_desc IN('SQL_SCALAR_FUNCTION','SQL_STORED_PROCEDURE','SQL_TABLE_VALUED_FUNCTION','USER_TABLE','VIEW')
ORDER BY type_desc,name