非复制列仍会触发复制
我的表中有几列已添加到我的出版物文章中。 当复制中未包含的列发生更改时，它似乎仍然会更新 msrepl_tran_version，我认为它仍然分配用于复制的行。 这就是 SQL-Server 的工作原理吗？ 有没有办法告诉 sql 仅在文章中包含的列更改时才复制行，而不是在更改非复制列时复制行？
I have a few columns in a table that are added to my publication articles.
When a change on a column that is not included in replication occurs, it still seems to update the msrepl_tran_version which i assume still assigns the row for replication.
Is this how SQL-Server works?
Is there a way to tell sql only to relicate rows when a colum that is included in the articles is changed and not when a non-replicated column is changed?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
除了破解系统生成的触发器和过程（非常非常非常不鼓励）之外，没有其他方法可以避免这种情况。我强烈建议您在 Microsoft Connect 中输入错误/建议，概述此问题以及它如何影响您的环境。有 您可能还想为您的事业招募其他人。
There is no way to avoid this aside from hacking the system-generated triggers and procedures (which is very, very, very strongly discouraged). I'd strongly encourage you to enter a bug/suggestion at Microsoft Connect outlining this issue and how it is affecting your environment. There are others you may want to recruit in your cause as well.