Determining the version of a Microsoft SQL database

This was driving me nuts for a little bit. Once I found out how easy it is, I was flabbergasted.

In SQL 2000

1. Open up Enterprise Manager
2. Right-click on the database
3. Click on Properties
   
4. Click on Options
5. Look under Compatibility Level
   

In SQL 2005

1. Open up SQL Management Studio
   
2. Right-click on the database
3. Click on Properties
   
4. Click on Options
5. Look under Compatibility Level

Database Compatibility Levels:
SQL Server 2008 (100) - SQL Server 2008
SQL Server 2005 (90) - SQL Server 2005
Database Compatibility Level 80 - SQL Server 2000
Database Compatibility Level 70 - SQL Server 7
Database Compatibility Level 65 - SQL Server 6.5
Database Compatibility Level 60 - SQL Server 6.0