SQL Server 2005's new encryption functions enable the database engine ... OPEN SYMMETRIC KEY dboSymKey DECRYPTION BY CERTIFICATE dboCert; UPDATE Encrypted SET Encrypted.CardNumber = ...

I realized after reviewing the past few posts that I omitted a new piece of functionality introduced in SQL Server 2008 R2 ... There are two registry keys that must be set (if they don't already ...