sp_mergedummyupdate (T-SQL)

Does a dummy update on the given row so that it will be sent again during the next merge.

Syntax

sp_mergedummyupdate [@source_object =] 'source_object',
    [@rowguid =] 'rowguid'

Arguments

[@source_object =] 'source_object'

Is the name of the source object. source_object is nvarchar(386), with no default.

[@rowguid =] 'rowguid'

Is the row identifier. rowguid is uniqueidentifier, with no default.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_mergedummyupdate is used in merge replication.

sp_mergedummyupdate is useful if you write your own alternative to the Replication Conflict Viewer (Wzcnflct.exe).

Permissions

Only members of the db_owner fixed database role can execute sp_mergedummyupdate.

See Also