Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuNí thacaítear leis an mbrabhsálaí seo a thuilleadh.
Uasghrádú go Microsoft Edge chun leas a bhaint as na gnéithe is déanaí, nuashonruithe slándála, agus tacaíocht theicniúil.
Applies to:
SQL Server
Azure SQL Managed Instance
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 = ] N'optname' ]
[ ; ]
The name of the replication option to query for. @optname 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 isn't returned. |
Column name | Data type | Description |
---|---|---|
optname |
sysname | Name of the replication option and can be one of the following values: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.
Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniu