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 |
|
avijit_mca
Posting Yak Master
109 Posts |
 Posted - 2011-04-23 : 02:42:35
|
| I hv production DB. i want to encrypt a table coulm with out creating any DB schema.i hv gone through different option 1. need to create colum with varbinary & then .... following steps. I know that option but its production server where new schema change not possible. even no change happen from application point. means insert script will be remain same in Application level.Pls let me know if any option available in SQL server with creating any new schema.Regards,avijit |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-04-23 : 07:25:00
|
| Will Transparent Data Encryption available in Enterprise edition help? I have not tried it or even read in detail about it, but you may want to investigate if that is a possibility. See details here: http://msdn.microsoft.com/en-us/library/cc278098(v=sql.100).aspxAccording to them, "Transparent data encryption (TDE) is a new encryption feature introduced in Microsoft® SQL Server™ 2008. It is designed to provide protection for the entire database at rest without affecting existing applications." |
 |
|
|
|
|
|
Encrypton Column Level