sp_helpreplicationdboption (T-SQL)

Shows the databases that have the replication option enabled.

Syntax

sp_helpreplicationdboption [[@dbname =] 'dbname'] [,[@type =] 'type']

Arguments

[@dbname =] 'dbname'

Is the name of the database. dbname is sysname, with a default of %.

[@type =] 'type'

Is whether replication is allowed. type is sysname, and can be one of the following values.

 

Value	Description
publish	Transactional replication allowed
merge publish	Merge replication allowed
replication allowed (default)	Either transactional or merge replication allowed.

Result Sets

Remarks

sp_helpreplicationdboption is used in snapshot, transactional, and merge replication.

Permissions

Execute permissions default to the public role.

See Also