GilaMonster (7/15/2014)
TDE is entire database encryption. Transparent encryption, data encrypted on disk, decrypted in memory. It protects against the theft of the data files or the backups. It doesn't protect columns.To encrypt a column, you want to use the encryption functions, like EncryptByKey and DecryptByKey when you're inserting/updating/deleting data.
Oh Yes thank you.
How can I do the following without creating an additional column and have one column to store the SSN?
Do you have a simple example please?
Just say for example that I have a Table Named Mytable and a Column Named SSN. How do I encrypt it?
Thank you.:-)
http://msdn.microsoft.com/en-us/library/ms179331.aspx">
http://msdn.microsoft.com/en-us/library/ms179331.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/