Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
sp_helpreplicationoption [ [ @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. |
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. |
0
(success) or 1
(failure).
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
.
Execute permissions default to the public role.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today