SQL合并复制:如何判断已更改的内容. [英] SQL Merge replication : How to tell what has changed.

问题描述

我有一个关于合并复制的查询.是否有任何存储过程可以准确地向我提供服务器上已更改的列值，因此在下一次复制会话中会将行复制到订阅服务器上?

我已经查看了此链接 http://www.replicationanswers.com/Script9.asp允许我获取所有需要复制的行的信息.但我想知道这些行已更改的特定列.

解决方案

您可以引用sys.sp_showlineage，也可以引用sys.sp_showcolv，但是您正在沿着系统内部的道路前进，这需要大量的学习和理解./p>

I have a query regarding the merge replication. Is there any stored procedure which gives me exactly the column values that have been changed at the server, because of which the row will be replicated to the subscriber in the next replication session ?

I have looked at this link http://www.replicationanswers.com/Script9.asp which allows me to get the info of all the rows that need to be replicated. But i want to know the specific columns that have changed for these rows.

解决方案

You can reference sys.sp_showlineage and possibly sys.sp_showcolv, but you are heading down a path of system internals which requires a great deal of learning and understanding.

这篇关于SQL合并复制:如何判断已更改的内容.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！