Detecting if SQL Server runs in emulation mode

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Detecting if SQL Server runs in emulation mode

Message

From

07/04/2015 16:23:47

07/04/2015 16:21:33

General information

Forum:

Microsoft SQL Server

Category:

Other

Title:

Environment versions

SQL Server:

SQL Server 2012

Application:

Web

Miscellaneous

Thread ID:

01617970

Message ID:

01617983

Views:

>Try this...
>
>to view it...
>
>

SELECT compatibility_level FROM sys.databases WHERE name = 'AdventureWorks2012'

>
>To set it...
>
>

ALTER DATABASE AdventureWorks2012 SET COMPATIBILITY_LEVEL = <version level>

Thanks