drop function replication definition

Drops a function replication definition and its user-defined function.

Syntax

drop function replication definition function_rep_def

Parameters

Examples

Usage

  • Use drop function replication definition to remove a function replication definition.

  • Before you can drop a function replication definition, you must drop all subscriptions for it.

  • Execute drop function replication definition at the primary Replication Server for the function replication definition.

  • After you drop the stored procedure defined by this function replication definition, execute sp_setrepproc in the database, setting the procedure’s replicate status to 'false'. This stops the RepAgent from transferring log entries to the Replication Server.

  • Replication Server distributes information about the dropped function replication definition to qualifying sites through the replication system. The changes do not appear immediately at all such sites because of normal replication system lag time.

Permissions

drop function replication definition requires “create object” permission.

Related reference
alter applied function replication definition
alter request function replication definition
check subscription
create applied function replication definition
create request function replication definition
create subscription
define subscription
drop subscription