Compatibility Level is the propery set for databases which tells SQL Server how to interpret T-SQL statements. In each compatibility level Microsoft has removed or added some features of T-SQL statements, setting this would allow SQL server to interpret those T-SQL commands and work properly. In SQL server 2008 the following are the compatibility levels supported.
- 80 (SQL Server 2000)
- 90 (SQL Server 2005)
- 100 (SQL Server 2008)
Hence those who are planning to migrate to SQL Server 2008 should change their T-SQL statements (i.e in procedures or functions) if they have any database with compatibility level less than 80 to work well and good in SQL 2008.You can change compatibility level of the database either in GUI under database properties or else using the below system SP “sp_dbcmptlevel".
0 Comments.