Date: 01/03/08 (SQL Server)    Keywords: database, sql

Is there any way to simply check what the compatibility level is on a database without changing it in SQL Server 2005?

Everything I've found points to sp_dbcmptlevel, which will not simply return the level the database is currently at, it requires you to enter a value to change it to. I need to return the current compatibility level, not write over it.

Source: http://community.livejournal.com/sqlserver/65674.html