Credit Card Data encryption | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Credit Card Data encryption

Hi, I wanted secure Credit card data in sql server. What options do I have and what would be the best solution? -Nilay

I’d suggest encrypting/decrypting on the client using something like the cryptoAPI, then storing the encrypted value in the database. This ensures that the data is transferred encrypted too Cheers
There are cases however where T-SQL is not as strong. A good example is integer or floating point type numeric calculations. One of those is crypto. Say you get data in from your customer with their credit card number, and you want to encrypt that before you store it in the database. Doing that in T-SQL is impossible. Today you would have to write an XP (Extended Stored Procedure) in C++. _________
Satya SKJ