Edit

Share via

sp_getmergedeletetype (Transact-SQL)

  • Article
  • 11/24/2023

Applies to: SQL Server

Returns the type of merge delete. This stored procedure is executed at the Publisher on the publication database or at the Subscriber on the subscription database.

Transact-SQL syntax conventions

Syntax

sp_getmergedeletetype
    [ @source_object = ] N'source_object'
    , [ @rowguid = ] 'rowguid'
    , [ @delete_type = ] delete_type OUTPUT
[ ; ]

Arguments

[ @source_object = ] N'source_object'

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

[ @rowguid = ] 'rowguid'

The row identifier for the delete type. @rowguid is uniqueidentifier, with no default.

[ @delete_type = ] delete_type OUTPUT

The code indicating the type of delete. @delete_type is an OUTPUT parameter of type int, and can be one of these values.

Value Description
1 User delete
5 Partial delete
6 System delete

Remarks

sp_getmergedeletetype is used in merge replication.

Permissions

Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_getmergedeletetype.

Related content