MSSQL Compatibility Level

Lets you specify which features will be available to the database and enables you to ensure compatibility with applications written for earlier versions of SQL Server. By default, the Compatibility level drop-down list box is set to SQL Server 2008 (100). The supported compatibility level settings are: 80 (SQL Server 2000), 90 (SQL Server 2005), 100 (SQL Server 2008).

Leave a Reply

Your email address will not be published. Required fields are marked *