Some additional notes to those that may not know.

TDE is available only in SQL 2008 and above, and only in the Enterprise Edition.

Column-level encryption is available in SQL 2005 and above, even in all the Express Editions (free).

In both cases, make sure you backup and store securely the keys/certificates/SMK's. These would be needed to move the database to another server if needed.