Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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! –  mdresser Nov 5 '09 at 17:34

Your Answer

 
discard

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.