How can i encrypt data (a column) when they're stored and decrypt them automatically when they're used without changing the way the application is retrieving the column? Meaning, how can i simplify application development by performing all encryption transparently at the database level? Is this possible in MSSQL?
Cheers, thanks for the response guys. However, maybe i shouldn't have used the term 'Transparent'. What i was trying to ask is if there is a way to encrypt data when storing into the database and decrypting when reading from the database using the application that i have written. My application uses normal SQL statements to retrieve data. Meaning, is there like a layer between the database and the application that can do this?