How to check the Database compatibility level in SQL 2005?

Use the below commands to check and change a db compatibility level

To check compatibility level exec sp_dbcmptlevel 'yourdbname'
Eg: exec sp_dbcmptlevel 'yourdbname'


To change compatibility level exec sp_dbcmptlevel 'yourdbname',80
Eg: exec sp_dbcmptlevel 'yourdbname',90