Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Simple question; How do you determine the compatibility level of a SQL Server 2005 database? I've looked at the properties dialog in Sql Management Studio but can't find anything there.

share|improve this question
up vote 2 down vote accepted

In SSMS it's in the properties page of the database in question under Options in the menu on the left. 3rd drop-down from the top underneath Collation and Recovery model.

You can also use sp_dbcmptlevel to check it via TSQL:

sp_dbcmptlevel 'DatabaseName'

60 = SQL 6.0
65 = SQL 6.5
70 = SQL 7.0
80 = SQL 2000
90 = SQL 2005
100 = SQL 2008

share|improve this answer
Brilliant, I was obviously being stupid to miss that! – Matthew Dresser Nov 5 '09 at 17:34

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.