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 iconTransact-SQL Syntax Conventions

Syntax

sp_helpreplicationoption [ [ @optname =] 'option_name' ]

Arguments

  • [ @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.

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column name Data type Description

optname

sysname

Name of the replication option and can be one of the following:

transactional

merge

value

bit

For internal use only.

major_version

int

For internal use only.

minor_version

int

For internal use only.

revision

int

For internal use only.

install_failures

int

For internal use only.

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.

See Also

Reference

System Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance