sp_getmergedeletetype (Transact-SQL)
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
.