Transact-SQL Reference

sp_helpreplicationoption

Shows the types of replication options enabled for a server. This stored procedure is executed at the Publisher on the publication database.

Syntax

sp_helpreplicationoption [ [ @optname =] 'option_name' ]

Arguments

[@optname =] 'option_name'

Is the name of the replication option to query for. option_name is sysname, with a default of NULL. If NULL, then the result set will contain all types of replication options activated on that database. If transactional, the result set will contain information only about the transactional publication. If merge, the result set will contain information about the merge publication only.

Result Sets
Column name Data type Description
optname sysname Name of the replication option type.
value bit For internal use only.
major_version int For internal use only.
minor_version int For internal use only.
revision int For internal use only.
install_failures int For internal use only.

Remarks

sp_helpreplicationoption is used to get information on transactional replication and merge replication on a particular server. To get information on a particular database, use sp_helpreplicationdboption.

Permissions

Execute permissions default to the public role.

See Also

System Stored Procedures