I've always used the system stored procedure sp_dbcmptlevel for finding out or altering the compatibility levels of our databases. I've used sp_helpdb but wasn't sure it provided the compatibility level as well. Fun q.