Export (0) Print
Expand All
Expand Minimize

sp_helpreplicationoption (Transact-SQL)

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

Topic link icon 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

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.

Community Additions

ADD
Show:
© 2014 Microsoft