Edit

Share via

sp_helpreplicationoption (Transact-SQL)

  • Article
  • 05/21/2024

Applies to: SQL Server Azure SQL Managed Instance

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

Transact-SQL syntax conventions

Syntax

sp_helpreplicationoption [ [ @optname = ] N'optname' ]
[ ; ]

Arguments

[ @optname = ] N'optname'

The name of the replication option to query for. @optname is sysname, with a default of NULL.

Value Description
transactional A result set is returned when transactional replication is enabled.
merge A result set is returned when merge replication is enabled.
NULL (default) A result set isn't returned.

Result set

Column name Data type Description
optname sysname Name of the replication option and can be one of the following values:

transactional
merge
value bit Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
major_version int Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
minor_version int Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
revision int Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
install_failures int Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

Return code values

0 (success) or 1 (failure).

Remarks

sp_helpreplicationoption is used to get information about replication options enabled on a particular server. To get information on a particular database, use sp_helpreplicationdboption.

Permissions

Execute permissions default to the public role.

Related content