SQL-DMO
CompatibilityLevel Property (MergePublication2, TransPublication2)
The CompatibilityLevel property returns a SQLDMO_REPLCOMPLEVEL_TYPE constant that indicates the feature set currently supported by the publication.
Applies To
| MergePublication2 Object | TransPublication2 Object |
Syntax
object.CompatibilityLevel
object
Expression that evaluates to an object in the Applies To list
Data Type
Long, enumerated
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetCompatibilityLevel(SQLDMO_REPLCOMPLEVEL_TYPE *pRetVal);
Returns
| Constant | Value | Description |
|---|---|---|
| SQLDMOReplCompatibilityLevel_70 | 10 | Microsoft® SQL Server™ version 7.0 |
| SQLDMOReplCompatibilityLevel_70SP1 | 20 | SQL Server 7.0 Service Pack 1 |
| SQLDMOReplCompatibilityLevel_70SP2 | 30 | SQL Server 7.0 Service Pack 2 |
| SQLDMOReplCompatibilityLevel_80 | 40 | SQL Server 2000 |
Remarks
If an application calls CompatibilityLevel on an instance of SQL Server, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000" are returned.