Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pramod21
Yak Posting Veteran
64 Posts |
 Posted - 2011-10-20 : 02:05:56
|
| Through TDE can we encrypt entire table, so that when we use select statement it will only display encrypted data not the original data..is it possible to show only encrypted data for all the columns in table, when we use select command ?? |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2011-10-20 : 13:37:08
|
| I'm not sure what you're asking. How does your second sentence differ from your first? |
 |
|
|
yhchan2005
Starting Member
26 Posts |
Posted - 2011-10-21 : 00:19:22
|
| you can implement cell level encryption. But this has some limitation on it and you need to change the column data type to varbinary and you program also need to change to handle this.they will have performance impact to your database and please read the book online for more info before you decide to use it. |
|
|
|
pramod21
Yak Posting Veteran
64 Posts |
Posted - 2011-10-21 : 01:40:33
|
| thanks ..... |
|
|
|
|
|
|
ecryption