Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic


SQL Server 2000

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


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. If NULL, then the result set will contain all types of replication options activated on that database. If transactional, the result set will contain information only about the transactional publication. If merge, the result set will contain information about the merge publication only.

Result Sets
Column name Data type Description
optname sysname Name of the replication option type.
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.


sp_helpreplicationoption is used to get information on transactional replication and merge replication on a particular server. To get information on a particular database, use sp_helpreplicationdboption.


Execute permissions default to the public role.

See Also

System Stored Procedures

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.