| title | sp_helpreplicationoption (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/04/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | replication | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | ef988dbc-dd0b-4132-80ab-81eebec1cffe | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEappliesto-ss-asdbmi-xxxx-xxx-md]
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 =] 'option_name' ]
[ @optname = ] 'option_name'
Is the name of the replication option to query for. option_name 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 is not returned. |
| Column name | Data type | Description |
|---|---|---|
| optname | sysname | Name of the replication option and can be one of the following: transactional merge |
| value | bit | [!INCLUDEssInternalOnly] |
| major_version | int | [!INCLUDEssInternalOnly] |
| minor_version | int | [!INCLUDEssInternalOnly] |
| revision | int | [!INCLUDEssInternalOnly] |
| install_failures | int | [!INCLUDEssInternalOnly] |
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.