CompatibilityLevel Property (MergePublication2, TransPublication2)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The CompatibilityLevel property returns a SQLDMO_REPLCOMPLEVEL_TYPE constant that indicates the feature set currently supported by the publication.
Syntax
object
.
CompatibilityLevel
Parts
- object
An 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 |
SQLDMOReplCompatibilityLevel_90 |
50 |
SQL Server 2005 |
Remarks
If an application calls CompatibilityLevelon an instance of SQL Server, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.