The MSreplication_options table stores the type of replication that is installed. This table is stored in the master database.
| Column name | Data type | Description |
|---|---|---|
| optname | sysname | Type of replication. Values are transactional and merge. |
| value | bit | Internal status information. |
| major_version | int | Reserved for future use. |
| minor_version | int | Reserved for future use. |
| revision | int | Reserved for future use. |
| install_failures | int | Reserved for future use. |