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

Freezing panes in Excel 2008 for Mac

I recently ran into a weird problem in Excel 2008 on a Mac. I couldn't freeze rows.

To freeze rows in Excel 2008 on a Mac:

1. Put your cursor where you want to freeze your rows or columns in Excel
   
2. Go to View
3. Change it to Normal
4. Go to Windows and select Freeze Panes