August 24, 2008 Leave a Comment
SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server.
- 60 = SQL Server 6.0
- 65 = SQL Server 6.5
- 70 = SQL Server 7.0
- 80 = SQL Server 2000
- 90 = SQL Server 2005
- 100 = SQL Server 2008
Changing the compatibility level in SQL Server may change the behavior of specific of the functionality of the SQL Server. Be sure to research and test before changing compatibility levels.
Sp_dbcmptlevel dbname, 100
This TSQL will generate the following output:
The current compatibility level is 90.
The current compatibility level is 100.
Once you change the compatibility level, you will want to be sure that your system still runs correctly.