SQL Query Analyzer: How can I check database compatability mode?

Question

How can I check database compatability mode in query analyzer version 8?

score 0 · Answer 1 · answered Nov 03 '10 at 15:13

0

select compatibility_level 
from sys.databases 
where name = db_name()

answered Nov 03 '10 at 15:13

Mitch Wheat

score 0 · Accepted Answer · answered Nov 03 '10 at 15:33

Is this SQL Server 2000? If so:

SELECT cmptlevel FROM master..sysdatabases WHERE name = db_name()

For SQL Server 2005 and 2008, as per Mitch Wheat, i.e.:

SELECT compatibility_level 
    FROM sys.databases 
    WHERE name = db_name()

In all versions, this works as well:

EXEC sp_dbcmptlevel '{insert name of your database here}'

2 Answers2