sp_compatmode

Verifies whether full compatibility mode can be used.

Syntax

sp_compatmode

Examples

Example 1 – Verifies whether full compatibility mode can be used:

1> sp_compatmode
-----------------
Compatibility mode is enabled.
WARNING: Compatibility mode may not be used when
statement cache and literalautoparam are enabled. 
WARNING: The configuration option 'histogram tuning 
factor' is configured with value '20', which is not the 
default value in ASE 12.5. This may lead to different 
accuracy of statistics and different query plans.

(return status = 0)
1>

Usage

This query reports whether compatibility mode is enabled or not. You see a warning if there are conflicts with the use of enable compatibility mode.

For more information, see the Migration Technology Guide.

Permissions

Any user can execute sp_compatmode. Permission checks do not differ based on the granular permissions settings.