RSSD Stored Procedures

Lists the RSSD stored procedures used with Replication Server.

• rs_capacity
  Helps you estimate stable queue size requirements. Use with the rs_fillcaptable stored procedure.
• rs_delexception
  Deletes a transaction in the exceptions log.
• rs_delexception_date
  Deletes a range of transactions identified by transaction date in the exceptions log in the rs_exceptscmd, rs_exceptshdr, and rs_systext system tables.
• rs_delexception_id
  Deletes a range of transactions identified by transaction ID in the exceptions log in the rs_exceptscmd, rs_exceptshdr, and rs_systext system tables.
• rs_delexception_range
  Deletes a range of transactions identified by originating site or user , or destination site in the exceptions log in the rs_exceptscmd, rs_exceptshdr, and rs_systext system tables.
• rs_dump_stats
  Extracts Replication Server statistics collected in the RSSD by admin stats to a comma-delimited format.
• rs_fillcaptable
  Records estimated transaction rates in the rs_captable table for an existing replication definition.
• rs_helpcheckrepdef
  Displays the replication definitions that exist only to define primary key columns, quoted table or column names, and customized function strings.
• rs_helpclass
  Displays error classes and function-string classes and their primary Replication Server and, in the case of inherited classes, the parent class.
• rs_helpclassfstring
  Displays the function-string information for function strings with function-string-class scope.
• rs_helpcounter
  Displays information about counters.
• rs_helpdb
  Provides information about databases that Replication Server knows about.
• rs_helpdbrep
  Displays information about database replication definitions associated with the current Replication Server.
• rs_helpdbsub
  Displays information about database subscriptions associated with the replicate data server.
• rs_helperror
  Displays the Replication Server error actions mapped to a given data server or Replication Server error number.
• rs_helpexception
  Displays transactions in the exceptions log.
• rs_helpfstring
  Displays the parameters and function string text for functions associated with a replication definition.
• rs_helpfunc
  Displays information about functions available for a Replication Server or for a particular replication definition.
• rs_helpobjfstring
  Displays the parameters and function-string text for target scope function strings.
• rs_helppartition
  Displays information about Replication Server partitions.
• rs_helppub
  Displays information about publications.
• rs_helppubsub
  Displays information about publication subscriptions and article subscriptions.
• rs_helprep
  Displays information about replication definitions.
• rs_helprepdb
  Displays information about databases with subscriptions for replication definitions in the current Replication Server.
• rs_helpreptable
  Displays information about replication definitions created against a primary table.
• rs_helprepversion
  Displays information on replication definition versions in the current Replication Server.
• rs_helproute
  Provides status information about routes.
• rs_helpsub
  Displays information about subscriptions.
• rs_helpuser
  Displays information about user login names known to a Replication Server.
• rs_init_erroractions
  Initializes a new error class.
• rs_send_repserver_cmd
  Executes replication definition change requests directly at the primary database.
• rs_ticket
  A stored procedure in the primary database that monitors Replication Server performance, module heartbeat, replication health and table-level quiesce.
• rs_zeroltm
  Resets the locator value for a database to zero (0). Use this stored procedure after you have used the Adaptive Server command dbcc settrunc to disable the secondary truncation point and truncate the logs, but before you restart Replication Server.