This is a post that just could not wait. LC posts on his blog how to determine what key was used to encrypt a piece of data in SQL 2005. Anyone doing encryption in SQL ’05 has GOT to keep this one in their toolboxes. Trust me, you’ll need it one day.