Verifying the Compatibility Level of Microsoft SQL Server

Verify that the database compatibility level is set to Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, or Microsoft SQL Server 2012.

To verify the compatibility level:

  1. In the Microsoft SQL Server Management Studio, right-click your primary database and select Properties.
  2. In Database Properties, click Options, and verify that the compatibility level is "SQL Server 2008 (100) or SQL Server 2012 (110)." If it is not, select that compatibility and click OK.
Parent topic: Primary Microsoft SQL Server Configuration and Verification