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.


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

  • Brilliant, I was obviously being stupid to miss that! Nov 5 '09 at 17:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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