Perform a Dummy Update for a Merge Article (Replication Transact-SQL Programming)
Applies to: SQL Server
Merge replication uses triggers as part of the replication process; when an update is made to published table, an update trigger fires. In some cases, data can be updated without the trigger firing, such as during the WRITETEXT and UPDATETEXT operations. In these cases, you need to add a dummy UPDATE statement explicitly to replicate the change. You can add a dummy UPDATE statement using replication stored procedures.
To add a dummy UPDATE statement
Execute the operation (for example, UPDATETEXT) on a row in a merge published table that requires a dummy update.
At the server (Publisher or Subscriber) on the database where the change was made, execute sp_mergedummyupdate (Transact-SQL). Specify the table on which the change was made for
@source_object
, and the unique identifier of the changed row for@rowguid
.Synchronize the subscription to replicate the changed row.
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho