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 |
|
Gordon.Davis
Starting Member
4 Posts |
 Posted - 2011-06-01 : 18:16:44
|
| HI All, I've about 50 Procdures in my Db,in which each Procedure has certian columns that are encrypted with Symmetric Key.Now I've to write script to decrypt that columns to normal plain text columns.Presently i'm doing like this Alter Procedure --------Open symmentric key by certificate-------Decrypting that particular column Now i've write a batch script for all the 50 Procedure so that the batch script would be deployed in QA as well as Prod.Could you Please help me is any other way i could be able to approach this. |
|
|
|
|
|
Procedure Encryption