Show TOC

drop function replication definitionLocate this document in the navigation structure

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

Syntax
drop function replication definition <function_rep_def>
Parameters
function_rep_def

The name of the function replication definition to drop.

Examples
Example 1

Drops the function replication definition named <titles_frep> and its user-defined function and function string:

drop function replication definition titles_frep
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.