How can i view my current DB's compatibility level?

[Balgar]

I can set the compatibility level by using :sp_dbcmptlevel
But before doing this - How can i view my current DB's compatibility level?
Any help appreciated

[Gurukiran]

Use the same sp_dbcmptlevel with the database name as thge argument. You will get a message like this :

"The current compatibility level is 65 "


------------
Balgar at 10/11/00 10:54:13 AM

I can set the compatibility level by using :sp_dbcmptlevel
But before doing this - How can i view my current DB's compatibility level?
Any help appreciated