I'm needing to implement data encryption for some security requirements We just got on with SQL 2008, and I see quite a bit about its encryption capabilities (down to the row level..pretty cool). I'm haven't been able to determine what effect doing so will have on existing applications that read/write to the tables I need to encrypt (e.g. credit cards).
Does the encryption/decryption happen at the DB level, and no changes would need to be made to the application?
If changes would need made, what would they be?
Looking to understand this a bit better. Any knowledge of the subject of encryption w/SQL 2008 in general is appreciated.