sp_compatmode

Verifies whether full compatibility mode can be used.

Syntax

sp_compatmode

Examples

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.