sp-helpreplicationoption-transact-sql.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
sp_helpreplicationoption (Transact-SQL)	sp_helpreplicationoption shows the types of replication options enabled for a server.	markingmyname	maghan	randolphwest	05/15/2024	sql	replication	reference	sp_helpreplicationoption sp_helpreplicationoption_TSQL	sp_helpreplicationoption	TSQL

sp_helpreplicationoption (Transact-SQL)

[!INCLUDE SQL Server SQL MI]

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

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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	[!INCLUDE ssInternalOnly]
major_version	int	[!INCLUDE ssInternalOnly]
minor_version	int	[!INCLUDE ssInternalOnly]
revision	int	[!INCLUDE ssInternalOnly]
install_failures	int	[!INCLUDE ssInternalOnly]

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

• System stored procedures (Transact-SQL)