sp_compatmode

Use sp_compatmode to verify if full compatibility mode can be used

Syntax

sp_compatmode

Example

1> sp_compatmode
2> go
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

The results of this query tell you whether compatibility mode is enabled or not. If there are conflicts with the use of enable compatibility mode warnings are generated.

Permissions

Any user can use this procedure.

sp_compatmode

Syntax

Example

Usage

Permissions

See also